cmhampton

Hello all, I am trying to build a client to consume a webservice, and have run into some strange issues. Here is my code: $securityCode = "A7D5B7D8-73E2-44D2-A6F8-4ACFB91843BF"; // The security code has been changed to an invalid code to prevent unwanted "visitors". $ProphecyConnect = new SoapClient("http://test.prophecyhealth.com/ProphecyConnect/ProphecyConnectXML.cfc?wsdl"); try { $params = …

Has anyone ever tried returning a ColdFusion structure through a web service? The WSDL type CF assigns to this is apachesoap:Map, but when I consume this in VB.NET, the data is null. I have converted the entire thing into a JSON string, and that seems to work, but it requires …

I need to return a class which inherits List(Of ) in a webservice. The consuming application simply views it as an array of the class, not a list. In fact, the Collection class is not even available to derive an object from. Class Definition: [CODE=VB.NET] Public Class TestResultCollection Inherits List(Of …

I am having issues parsing JSON data from a web service. The web service is local on my machine, and I have added it as a Web Reference. Simple data types from the service work perfectly. However, if I call a method that returns a complex structure (such as an …

I'm trying to make a list of sub titles that links to mid topic jumps on another page. As the sub titlles are the same for each main title and the midtopic jumps increment numerically- I thought I could use cfloop - but I can't get it to work - …

Hi all, I'm helping a friend redo his database queries and have run into something that I need some advice on. Let me first say that I am not a PHP developer, so please bear with me. I have two queries that I can merge together, but I will need …

I recently updated our servers to CF 8.0.1 and now none of my AJAX code works. I checked the XHR response in Firebug and instead of returning the requested data, it returns the HTML code for my site's home page. All of this was working before the update and I …

hi. my thread title seems strange but its really about comparing unlike values as an output. I want all values that are not LIKE the other values. To make things clearer. Here's my query: [ICODE]SELECT Records.[Officer ID], Records.[Plate Number], Records.[Violation Commited], Violations.[Violation Code], Records.[Street Name], Records.[City of Apprehension], Records.[Vehicle Category], …

Hello all, I am trying to do something like this.I have did this before with C# and asp.net but it was long back and currently am not able to recall anything similar. This time i need to make it work with [B]vb.net and ASP.net[/B] I want that only a administrative …

can anyone help me with code to auto carete a username. this should tahe the 4 letters of the user's name and assign a number from a sequence in a database. basically the username should be like "comp001" but it should verify if it exists in the database. please help. …

have anyone ever creates navigation buttons such as next,previous in coldfusion? can i see ours if you have created one?

I am not sure how to ask the question, but here goes. I have a multiline survey storing data about a specific project. I want to store the data in the following fields: proj_id strat_issue strat_goal strat_obj strat_value here is an example of my code [code=html]<form action="strat_survey.cfm?update=gogo" method="post"> <table width="90%" …

Greetings, I have a problem with CF code, and I assume it is because I am new to ColdFusion. I've searched the Web, the Adobe pages, the Forums here, tutorials, etc... I just can't find the answer to what I imagine to be a fundamental of CF. I just inherited …

Hello I seem to be having a problem, I have this query that pulls back correct results [CODE]SELECT hourStamp, SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage, SUM(CASE WHEN dateStamp BETWEEN DATEADD(d,DATEDIFF(d,0,GETDATE()),0) AND GETDATE() THEN 1 ELSE 0 END) as HourToday FROM webstats GROUP …

how to delete duplicate records from table.

I am sending a query result (query in CF8; data in MS SQL Server 2005) to an XML output (using the <cfxml variable="outputname"> and <cfcontent type="text/xml"><cfoutput>#toString(outputname)#</cfoutput> tags), using CF8. When the output (in SQL Server as nvarchar) contains special characters like "-40° to 70°C" the ° symbol causes the error; …

Hi all!!! This is my first post here so please feel free to move if it's in the wrong place :-) Ok, i am just starting out in web development, and i have created a data entry form in DW CS3 and succesfully link it into MySQL (big deal for …

Hi Trying to do multiple left outer joins on query of query. Have asked on forums if ColdFusion supports this, although there are workarounds for single left outer joins on query of query, it is not what I require. It appears that no one has attempted to do this on …

I have a MSSQL table that contains lots of duplicate records, is there a simple way to keep only one and remove all other duplicates? [CODE] mike M 60 mike M 60 mike M 60 [/CODE] I need only one record [CODE] mike M 60 [/CODE]

Right now I have a page set up that inserts a record into a DB that a user enterd. I have it set up to take them to another page that shows the the information that they entered. but I also have a cfmail tag that e-mails the same information …

Hi everybody! Could you teach me how to get back the “primary key”: (“id”), from an “insert query”? * [code=coldfusion]<cffunction name="insertData" access="public"> <cfargument name="formData" type="struct" required="yes"> <cfquery name="qInsert" datasource="mydata"> INSERT INTO mytable (email, firstname, name) VALUES ('#formData.email#', '#formData.firstname#', '#formData.name#') </cfquery> </cffunction>[/code] * How could I get back the primary key:”id” …

I use a page that pulls the content from a database, including the title of the document. How can I make that title to also be the browser title (content in the title tag)? Thanks!

I have [b]form.mydata[/b] coming to my action page with comma delimeter value: [b]adam,joe,ben,steve,jill,andy,david[/b] I want to seperate them and it works inside this loop: [code] <cfset myd = ""> <cfloop list="form.mydata" index="i" delimiters=","> <cfoutput> <cfset myd = "#i#"> #myd#<br /> </cfoutput> </cfloop>[/code] How do I get them to print outside …

Greetings. With help from CF geniuses, constructed a CF suggestion form on the web where data went into an Access database. Moved offices, PCs and servers. All went into the abyss :'( Have copies of web page for entry of information by customers, and confirming page showing customers what they …

I am writing a CF application that queries a Centura SQLBase DB--not my DB of choice, its an interface partner's DB! Some of the fields in the SQLBase DB are of type FLOAT, which for some reason CF is returning in scientific notation (i.e. 1.23653E7) rather than as a whole …

I am using cfexchangemail and it works fine with an email sent from bb or windows but when ever someone sends an email from a mac (entourage) the email id (UID) has special characters and cannot download the attachments. I get this message: Error processing the Exchange request. This error …

Hello, Not sure I'm in the right place for this question, so apologies if I am not. Also, please note I am not a Coldfusion programmer, but rather the office administrator and user of a company website that is built using Coldfusion. Our company uses Mac computers exclusively. Most of …

My web sever has ColdFusion MX 7 I would like to know what ver. of dreamweaver do I need to code for it ?

r CF MX 7 the CF admin setting for database queries timeout is set at 100. Because of this some of my queries timeout and give me back a timeout message. I am trying to overwrite it in my cfquery working with Oracle 9i: [code] <cfquery datasource="cityOra" [color=red]timeout="300"[/color] name="queryOne"> select …

We are lookign to purchase an applciation to mail newsletters, mass email etc... are there any good oens for sale you anyone can reccomend? thnx