|
| |
|
|
box
Posts: 130
Joined: 12/10/2002
Status: offline
 |
what is wrong? - 1/13/2008 19:49:31
<!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="INSERT INTO ptinfo (firstname, middlename, lastname, status, socialnumber, birthdate, gender, address, city, region, country, zip, homephone, cellphone, workphone, emailaddress, employer, jobtitle, emername, emerperson, emerphone, abdomen, arms, buttocks, fot, bot, sot, specialnote, howfound, referredby, followup, enrolled, submittedby, todaydate) VALUES ( '::firstname::', '::middlename::', '::lastname::', '::status::', '::socialnumber::', '::birthdate::', '::gender::', '::address::', '::city::', '::region::', '::country::', '::zip::', '::homephone::', '::cellphone::', '::workphone::', '::emailaddress::', '::employer::', '::jobtitle::', '::emername::', '::emerperson::', '::emerphone::', '::abdomen::', '::arms::', '::buttocks::', '::fot::', '::bot::', '::sot::', '::specialnote::', '::howfound::', '::referredby::', '::followup::', '::enrolled::', '::submittedby::', '::todaydate::') "
fp_sDefault=""
fp_sNoRecords=""
fp_sDataConn="pt"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--#include file="_fpclass/fpdbrgn2.inc"-->
I get the following error:
Database Results Error
Unable to find operator in query string. Query string currently is INSERT INTO ptinfo (firstname, middlename, lastname, status, socialnumber, birthdate, gender, address, city, region, country, zip, homephone, cellphone, workphone, emailaddress, employer, jobtitle, emername, emerperson, emerphone, abdomen, arms, buttocks, fot, bot, sot, specialnote, howfound, referredby, followup, enrolled, submittedby, todaydate) VALUES ( '::firstname::', '::middlename::', '::lastname::', '::status::', '::socialnumber::', '::birthdate::', '::gender::', '::address::', '::city::', '::region::', '::country::', '::zip::', '::homephone::', '::cellphone::', '::workphone::', '::emailaddress::', '::employer::', '::jobtitle::', '::emername::', '::emerperson::', '::emerphone::', '::abdomen::', '::arms::', '::buttocks::', '::fot::', '::bot::', '::sot::', '::specialnote::', '::howfound::', '::referredby::', '::followup::', '::enrolled::', '::submittedby::', '::todaydate::')
Any idea? Thanks
|
|
|
|
box
Posts: 130
Joined: 12/10/2002
Status: offline
|
RE: what is wrong? - 1/13/2008 21:34:17
if i use frontpage form to insert the data it works, so it doesnt look like reserved words! I dont know!
| |
|
|
|
bernieboy31
Posts: 80
Joined: 3/5/2005
From: London, United Kingdom
Status: offline
|
RE: what is wrong? - 1/14/2008 12:34:20
Hmm,
1. As the code looks like it has the "Spooky diet" have you tried a ' response.write fp_sQry' to see what the complete string looks like?
2. Are all the fields strings? If not, do you need the ' character to define every field? (See DRW Input syntax under http://www.outfront.net/spooky/advanced.htm)
HTH
| |
|
|
|
box
Posts: 130
Joined: 12/10/2002
Status: offline
|
RE: what is wrong? - 1/14/2008 18:25:51
thanks for reply if I add
response.write fp_sQry
response.end
I get the following just I dont know why does not work
INSERT INTO ptinfo (firstname, middlename, lastname, status, socialnumber, birthdate, gender, address, city, region, country, zip, homephone, cellphone, workphone, emailaddress, employer, jobtitle, emername, emerperson, emerphone, abdomen, arms, buttocks, fot, bot, sot, specialnote, howfound, referredby, followup, enrolled, submittedby, todaydate) VALUES ( '::firstname::', '::middlename::', '::lastname::', '::status::', '::socialnumber::', '::birthdate::', '::gender::', '::address::', '::city::', '::region::', '::country::', '::zip::', '::homephone::', '::cellphone::', '::workphone::', '::emailaddress::', '::employer::', '::jobtitle::', '::emername::', '::emerperson::', '::emerphone::', '::abdomen::', '::arms::', '::buttocks::', '::fot::', '::bot::', '::sot::', '::specialnote::', '::howfound::', '::referredby::', '::followup::', '::enrolled::', '::submittedby::', '::todaydate::')
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: what is wrong? - 1/16/2008 10:09:32
quote:
any idea please!
Is this an Access database and is todaydate a date field in the DB? If so:
'::todaydate::'
needs to look like this:
#::todaydate::#
That help any?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
box
Posts: 130
Joined: 12/10/2002
Status: offline
|
RE: what is wrong? - 1/17/2008 2:59:57
Thanks rdouglass for reply, todaydate is a text field, but what i did to fix the issue was to replace the fpclass folder with the older version! now is working, but I dont get it why!!! any idea? thanks
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
