Weird SQL query behavior

This one has me really confused.Can anybody tell me why this query returns three records cfquery name=getOpenItems datasource=myDS SELECT * FROM CADMODEL WHERE ITEMNAME IN ('211D1234','211D4567') /cfquery And this query returns an empty recordset? cfset itemNames = 211D1234','211D4567 cfquery

RE: Weird SQL query behavior

Oh yeahI always seem to forget this one.Thanks!My mind is obviously not up to full speed yet today. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 10:47 AM To: CF-Talk Subject: RE: Weird SQL query behavior This one has me really

Accessing query results by row number

Is there a way to access query results by referencing the record's row number?I've tried foo[1].Title to get the Title field in row 1 of my query named foo, but I get this error [Table (rows 1 columns TITLE): [TITLE: [EMAIL PROTECTED] ] is not indexable by 1 I know I can loop through the

RE: Accessing query results by row number

Just what I needed!I'd tried to find this in my docs, but just couldn't. Thank you Mike and Dave and Dave. :) -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 2:30 PM To: CF-Talk Subject: RE: Accessing query results by row number

RE: Chr() for a tab?

chr(9) is a tab. -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 9:05 AM To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. _ [Todays Threads] [This

RE: how to re-query a cfquery?

I've always used the form variables in further coding in the page instead of re-querying the database, too.(Usually just to display them to the user so they can be sure of what they just entered to the database.)I worry, however, that it's not good form.Is there any reason why this might not be a

RE: Phone Number for Macromedia Contact

I don't have a name to call specifically since the Sys Admin was the one who called to get our demo extended.He just called their customer service number. US and Canada: 1-800-470-7211 (Toll Free) Outside US and Canada: +1-415-553-7186 http://www.macromedia.com/support/email/cscontact/

RE: CF license limitations

Call Macromedia and explain your situation.They may be willing to work with you.We had a similar situation last year, and they extended the length of the demo for us. -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 6:46 AM To: CF-Talk

RE: yahoo and selling fabric

I checked into a Yahoo store for my husband's business web site.They only support PHP and Perl.So, if you're planning on using ColdFusion to build your catalog, you need to look elsewhere. If you haven't already, you may want to check out www.fabric.com http://www.fabric.com . Their navigation

RE: yahoo and selling fabric

We had some special needs that didn't allow us to use Yahoo's catalog (by catalog I mean where the shopper searches for products and puts them in the cart), so we were going to put together our own catalog and use their check-out services.The rest of our web site was already built in ASP, so we

Using recursion with query results

I'm trying to build a recursive routine that will go through my query results and display them in a tree structure.There are four fields in each row of my results.Is it possible for me to pass an entire row of my query results to a custom tag?If so, when I come back out of my recursive routine,