Referencing Query Object

Has anyone seen anything funky when reference elements in query objects using stored procs, MSSQL 2000? I've double checked the result set numerous times, and verified the field i'm referencing is indeed returned, however everytime I try to reference the field in CF, I get an undefined element

RE: Referencing Query Object

CFQUERY NAME=newQuery DATASOURCE=DATASOURCE {call procedure( #argument1#, #argument2#, #argument3# )} /CFQUERY CFSET return = #newQuery.returnID# Source above... its a simple no brainer which works on older versions of CF using the same datasource. I've double checked the result set from the

Dissappearance of Query Variables

Ok, this get even wierder. I have a resultset that returns 1 record. When dumping the query, I see all the fields and the correct values, but now I get an UNDEFINED ELEMENT on queryname.RecordCount. Anyone else see any strange stuff with cfmx and queries? Jordon

RE: CF Palm PQAs

Are you using and Coldfusion style loops to build content in your files??? If so, then remember you are building strings of source which will dramatically increase filesize (pending on the size of the loop). Example being creating a bunch of OPTION tags from a query result set. File saved will

CF/MS SQL Wierd Errod

We're having a very strange error with one of our servers here, and we can't quite seem to figure it out. We have CF server 4.01 running with MS SQL Server 7 (running on same server). Every time we run a query through an ODBC DSN setup through CF Admin, the server hits 100% CPU usage and will

RE: WAP and WML...

, Inc. 4107 Laguna Street Coral Gables, Florida 33146 (305) 442-8060 x230 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Jordon Saardchit [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 13, 2000 2:59 PM To: [EMAIL PROTECTED] Subject: RE: WAP and WML... nokia has

RE: How do I carry an Array over to another page? - HELP!!!!

Pop the array into a Structure, serialize the structure with CFWDDX and pass the WDDX packet to your next page. Then deserialize the WDDXPacket on the next page and voila. You have your array. -Jordon -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: Detect if JS is Enabled

A cookie is proprietary coldfusion its just info stored in the header. Coldfusion just provides a way to access that info, as do other application servers (eg, ASP). -J -Original Message- From: Gregory Weiss [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 11:17 AM To:

RE: Detect if JS is Enabled

damnit... i mean is NOT proprietary coldfusion... heh... looks like i got a case of the mondays. -Original Message- From: Jordon Saardchit [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 11:53 AM To: [EMAIL PROTECTED] Subject: RE: Detect if JS is Enabled A cookie is proprietary

RE: Extraneous end tag error message

Had the same issue mising CFFORM with standard HTML form elements. Either use just the FORM tag, or change the SELECT tags to CFSELECT and you should be fine. Thats how i resolved the issue -Jordon -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Monday, April

RE: cfquery vs. cftransaction

Best way to do it would be in a Stored Procedure, wrapped in a SQL transaction. -J -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 7:56 AM To: Cf-Talk@Houseoffusion. Com Subject: cfquery vs. cftransaction Let me try this again please. Is

RE: getting fields of a table(sql)

Much easier Joe after you query, call query variable 'queryname.ComlumnList'. Will give you a comma delimited list of the queries column names -J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 2:05 PM To: [EMAIL PROTECTED]

RE: Duplicate Values in a query

eliminate the duplicates from the SQL side the DISTINCT keyword. SELECT DISTINCT blah FROM tableBlah WHERE columnBlah = moreBlah -J -Original Message- From: Lincoln Manning [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 30, 2000 1:26 PM To: [EMAIL PROTECTED] Subject: Duplicate

RE: looping through a mailing list

Yer wasting a lot of processing power in coldfusion unnecessarily. You should build a where clause that replicates the conditions you are searchinf for in your CFIF, that way you just loop over the result set and send the email to every single record. SQL Will handle that much faster than Cold

RE: CFIF Problem with OR

Your syntax is incorrect. right now you're telling it to evaluate the block of code if ID is anything. Look at it this way... if ID is 43, it is STILL NOT 1... which means your code will execute. Change them to ANDs. Jordon -Original Message- From: Michel Gagnon [mailto:[EMAIL

RE: Variable in stored procedures

absolutely... except, in your case, you'd need the syntax: create procedure test @tablename nvarchar(255), @columname nvarchar(255) AS EXEC ('select ' + @columname + 'from ' + @tablename) That'll do it for ya. -Jordon -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]]