For starters column names should NEVER have spaces in them. An underscore perhaps "_" but not spaces. You need to have that rectified. Dang newbie database designers.
What db are you using (thinking MSAccess or something equally pitiful). Use CFDUMP var="QueryName" for detailed info on your query - requires MX 7.x or above. On 05/03/07, skateboard.com.au <[EMAIL PROTECTED]> wrote: > > Hey Guys > > I have a query object. I do not know the names of the columns so I am > using the columnlist variable. Some of the column names have spaces in > them which is causing me some trouble. Can someone point me in the right > direction on how to escape the space etc etc so I can output the query.. > > thanks in advance > > Drew Peacock > > > > > > > -- Peter Tilbrook ColdGen Internet Solutions President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA http://www.coldgen.com/ http://www.actcfug.com/ Tel: +61-2-6284-2727 Mob: +61-0432-897-437 Email: [EMAIL PROTECTED] MSN Messenger Live: Desktop General --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---