The problem is most likely to be with your DB insert query, not the
form. Or not directly anyway, either you are trying to insert a column
that doesn't exist or something similar. The alternative is that you are
not passing something in your form.
The quickest way to solve this is to comment out your query and output
the resulting SQL i.e. if you have the following query
<cfquery name="rsInsert" datasource="someDSN">
INSERT INTO tblTable(ID, item)
VALUES(#form.ID#,#form.Item#)
</cfquery>
change it to read the following:
<CFOUTPUT>
INSERT INTO tblTable(ID, item)
VALUES(#form.ID#,#form.Item#)
</CFOUTPUT>
<CFABORT>
Then copy the SQL into your DB and try to run it. This will tell you
what is missing.
Ellis C Wood BSc
Ellwood Web Solutions
T: 01623 459973
E: [EMAIL PROTECTED]
W: http://www.ellwoodwebsolutions.co.uk
-----Original Message-----
From: Lovelock, Richard J [mailto:[EMAIL PROTECTED]
Sent: 31 March 2004 13:15
To: '[EMAIL PROTECTED]'
Subject: FW: [ cf-dev ] Re:PROBLEMS WITH CONNECTION TO DB
-----Original Message-----
From: Lovelock, Richard J
Sent: 31 March 2004 13:13
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Re:PROBLEMS WITH CONNECTION TO DB
are you getting some error message when you submit the form - if so
what?
have you got debugging on?
_______________________________________________________
Regards,
Richard Lovelock,
Senior Application Analyst.
Westminster City Council - Web Support
Cap Gemini Ernst & Young
Southbank
95 Wandsworth Road
London
SW8 2HG
Tel: 0870 906 7482
_______________________________________________________
-----Original Message-----
From: sanjay sidar [mailto:[EMAIL PROTECTED]
Sent: 31 March 2004 12:44
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Re:PROBLEMS WITH CONNECTION TO DB
hi guys,
ive created a form using html, and an action page called action.cfm, the
problem is that im having problems when inserting information into my
form,
it doesnt seem to being entered into my database, below i have both
codes of
the form and the action page, pleaseee help, ive been riping my hair
out,
any help would be appreciated as you will be able to see im a complete
novice at using cf
f
=======================================================
This message contains information that may be privileged or confidential
and is the property of the Cap Gemini Ernst & Young Group. It is
intended only for the person to whom it is addressed. If you are not the
intended recipient, you are not authorised to read, print, retain, copy,
disseminate, distribute, or use this message or any part thereof. If you
receive this message in error, please notify the sender immediately and
delete all copies of this message.
=======================================================
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF
provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
