Cold Fusion Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingCold Fusion Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old September 29th, 2007, 06:26 PM
Nero Nero is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2007
Posts: 2 Nero User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 44 m 28 sec
Reputation Power: 0
Error executing the Database Query

Hello i have a problem retrieving a query from a form, im trying to "add new user" but i keep getting an error processing the request it says its a Synax error in INTO Statement.
Im using coldfusionMX7 and access 2007 database. any1 understand below? and have any idea on whats wrong?
The error occurred in C:\CFusionMX7\wwwroot\admin\Users\add.cfm: line 64

62 : <cfelse>
63 : NULL
64 : </cfif>
65 : )
66 : </cfquery>
Im still learning the code so not too hot. if you need more info from me to help solve my problem let me know what i need to provide. Thanks.
--------------------------------------------------


OMG i have just figured it out myself, after a few thoughts i thought i would try to find if any of my paramaters are reserved only to find out that "Password" is actually reserved in access, why havent anyone who works with access picked this up before? well anyway no need to reply to this message now as i worked it out.. Thanks

Last edited by Nero : September 29th, 2007 at 07:24 PM. Reason: Ihave worked it out myself

Reply With Quote
  #2  
Old September 4th, 2008, 08:25 AM
mgwalk mgwalk is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2008
Posts: 4 mgwalk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 41 m 9 sec
Reputation Power: 0
Well I can not see you insert statement but it should look like something like this
INSERT INTO table_name (field1,field2 etc...) VALUES " & Text1.value & "," & Text2.Value etc...

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingCold Fusion Development > Error executing the Database Query


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap