The database server is "SQLBase" by Gupta. I tried PHONE## and it works. Thanks,
Percy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 10:50 AM To: CF-Talk Subject: RE: CFQuery and SQLBase - alternative to using asterisk What database are you using (Access, SQL, Oracle, etc.). Also, can you SELECT PHONE# FROM TABLE1 ??? If so, then that's not your issue. If you can't SELECT PHONE#, try this: SELECT PHONE## FROM TABLE1 See if that works. Dave -----Original Message----- From: Perez, Percy [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 20, 2005 10:35 AM To: CF-Talk Subject: CFQuery and SQLBase - alternative to using asterisk Hello, I am having problems doing a simple SQL select. When I enter: SELECT * from TABLE1, I get an error message that the asterisk is an invalid character. However, if I used dreamweaver to view data, I get all the columns and records. If I do a select listing some of the fields it works. Also, the original database creators added a "PHONE#" field. Of course the # sign is not well liked by coldfusion. I trying using a bracket to escape the special character but no go. Unfortunately, I can not alter the table since it is provided by ADP (Payroll Company) and there is a GUI interface provided by them. Any suggestions? Thank you in advanced. Percy Systems Administrator Versa Products Company Inc 22 Spring Valley Road Paramus NJ 07652 Ph:201.843.2400 Fx: 201.843.2931 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54