Update Query syntax

Hi, I have a simple update query that is throwing an error: cfquery name=NewRec datasource=#Application.DSN# update icitem set lastchanged = '1/1/2008' where itemno in (#itemnos#) /cfquery The itemnos variable has the value: '1A703239', '1A703240', '1A703241', '1A703242',

Re: Update Query syntax

WHERE itemno IN (#preserveSingleQuotes(itemnos)#) or even better: WHERE itemno IN (cfqueryparam value=#itemno# cfsqltype=cf_sql_char list=true /) On Thu, Oct 23, 2008 at 12:21 PM, Ben Conner [EMAIL PROTECTED] wrote: Hi, I have a simple update query that is throwing an error: cfquery

Re: Update Query syntax

Thanks much, Charlie! --Ben WHERE itemno IN (#preserveSingleQuotes(itemnos)#) or even better: WHERE itemno IN (cfqueryparam value=#itemno# cfsqltype=cf_sql_char list=true /) ~| Adobe® ColdFusion® 8 software 8 is the most

problem on cfoutput query syntax too complex for cfmx

Hi everybody need help on the following: I have two cfquery which are cfquery name=english datasource=db select * from lang where langid=1 /cfquery cfquery name=spanish datasource=db select * from lang where langid=2 /cfquery cfparam name=Session.Lang default=1 CFSWITCH

Re: problem on cfoutput query syntax too complex for cfmx

scrap the hashes. cfset qtext=spanish cfoutput query=qtext On 04/12/06, alex poyaoan [EMAIL PROTECTED] wrote: Hi everybody need help on the following: I have two cfquery which are cfquery name=english datasource=db select * from lang where langid=1 /cfquery cfquery name=spanish

Re: problem on cfoutput query syntax too complex for cfmx

I think you'll find that that may need to be: cfset qtext=spanish cfoutput query=#qtext# You will need the hashes around 'qtext' for coldfusion to resolve it in to the desired name of your query (i.e. English or Spanish) Regards Rich On 12/4/06, Adrian [EMAIL PROTECTED] wrote: scrap the

Re: problem on cfoutput query syntax too complex for cfmx

And if we are being syntactically correct, you'll need the quotes around spanish... Actually. Apologies here... i am half asleep still and have only just finished the coffee... Adrian is completely correct another Americano please On 12/4/06, RichL [EMAIL PROTECTED] wrote: I think

Re: problem on cfoutput query syntax too complex for cfmx

scrap the hashes. cfset qtext=spanish cfoutput query=qtext On 04/12/06, alex poyaoan [EMAIL PROTECTED] wrote: THANKS A LOT ADRIAN THE CODE NOW WORKS.. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of

Query of Query Syntax

I am asking here, before I go searching and digging in the documentation and web resources, because you all often provide a better answer faster then I can on my own. Anyway, what SQL syntax, if any, is in a CF query of a query to manipulate and modify string content of fields? I have a

Re: Query of Query Syntax

Ian Skinner wrote: Anyway, what SQL syntax, if any, is in a CF query of a query to manipulate and modify string content of fields? Upper() and Lower(). Jochem ~| Special thanks to the CF Community Suite Silver Sponsor -

RE: Query of Query Syntax

You can use a normal SQL SELECT, however, there are limitations. I can't think of anything that isn't standard, however. M!ke -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 2:42 PM To: CF-Talk Subject: Query of Query Syntax I am asking

RE: Query of Query Syntax

PROTECTED] Sent: Friday, December 10, 2004 2:42 PM To: CF-Talk Subject: Query of Query Syntax I am asking here, before I go searching and digging in the documentation and web resources, because you all often provide a better answer faster then I can on my own. Anyway, what SQL syntax, if any

ColdFusion Server restarts on bad query syntax

ColdFusion 5 with latest odbc driver from microsoft , Sql Server 2000.. I noticed when the syntax is incorrect when querying a table such as a date/time or no ' ' for a string field, the coldfusion server restarts everytime, and the users get the typical Request canceled or ignored by

SQL Query Syntax

Here with a more appropriate subject line... -Original Message- From: fleming [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 5:30 PM To: '[EMAIL PROTECTED]' Subject: RE: Protecting Content / content leeching... A CF method? Hello Everyone, Does anyone know what syntax

Re: Query syntax

Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Chad [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, Aug

Re: Query syntax

This is TSQL syntax - (not cfml variable scope reference) dbo = database owner disproducts = table name product_name = table column name DESC - tells the Order by to sort the query resultset in Descending order Steve - Original Message - From: "Chad" [EMAIL PROTECTED] ORDER BY

Re: Query syntax

I meant "Table" owner - sorry This is TSQL syntax - (not cfml variable scope reference) dbo = database owner -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit