473,326 Members | 2,128 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

error in syntax eventhough correct?

im receiving a syntax error in my sql statement. i dont see anything wrong
with it, however i played with the database (access) and if i change all the
datatypes to "text" or "memo" my query runs successfully. i dont get it.
im running this on CFMX.

thanks!!

sql statement:

INSERT INTO tblProducts(site_id,
active,
description,
amount,
trialperiod,
rebillamount,
billcycle,
payperiods)
VALUES (1
0,
'test',
1.95,
3,
5.95,
30,
15)

database:
product_id autonumber
site_id number
active number
description memo
amount currency
trialperiod number
rebillamount currency
billcycle number
payperiods number
Nov 12 '05 #1
2 4954
On Sun, 30 Nov 2003 20:02:40 GMT, "diddydee" <di******@diddydee.com>
wrote:

I would try wrapping the Currency values with # signs.
-Tom.

im receiving a syntax error in my sql statement. i dont see anything wrong
with it, however i played with the database (access) and if i change all the
datatypes to "text" or "memo" my query runs successfully. i dont get it.
im running this on CFMX.

thanks!!

sql statement:

INSERT INTO tblProducts(site_id,
active,
description,
amount,
trialperiod,
rebillamount,
billcycle,
payperiods)
VALUES (1
0,
'test',
1.95,
3,
5.95,
30,
15)

database:
product_id autonumber
site_id number
active number
description memo
amount currency
trialperiod number
rebillamount currency
billcycle number
payperiods number


Nov 12 '05 #2
TC
Show us the actual code you are running.

What is CFMX?

TC
"diddydee" <di******@diddydee.com> wrote in message
news:c7******************************@news.teranew s.com...
im receiving a syntax error in my sql statement. i dont see anything wrong with it, however i played with the database (access) and if i change all the datatypes to "text" or "memo" my query runs successfully. i dont get it.
im running this on CFMX.

thanks!!

sql statement:

INSERT INTO tblProducts(site_id,
active,
description,
amount,
trialperiod,
rebillamount,
billcycle,
payperiods)
VALUES (1
0,
'test',
1.95,
3,
5.95,
30,
15)

database:
product_id autonumber
site_id number
active number
description memo
amount currency
trialperiod number
rebillamount currency
billcycle number
payperiods number

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Manuel | last post by:
I'm trying to compile glut 3.7.6 (dowbloaded from official site)using devc++. So I've imported the glut32.dsp into devc++, included manually some headers, and start to compile. It return a very...
8
by: Wescotte | last post by:
The error message Parse error: syntax error, unexpected $end in FILE on line X is one I run into frequently and I know the cause is I missed an ending quote. Is there an easy way to determine...
36
by: rhys | last post by:
My Gurus and Angels -- Please pardon this old-school programmer, only recently enlightened to open-source, having been trapped in the convenience of proprietary lingos for way too long. My...
3
by: SilvaZodiac | last post by:
Hi everyone, I'm still rather new to PHP code, and I have a syntax error. I've tried several different solutions, but it won't fix. It seems to suggest that I need a new bracket somewhere in the...
3
paulrajj
by: paulrajj | last post by:
hi to all, i am getting syntax error on my code.. Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in D:\xampp\htdocs\Dummy\paulraj\matrim\exam.php on line 62 ...
4
n8kindt
by: n8kindt | last post by:
i'm trying to allow my website to use a http://ourdomain.com/fname.lname/ format. i am fairly certain my regex syntax is correct. here's what i have: <IfModule mod_rewrite.c> RewriteEngine on...
10
by: benicio | last post by:
Parse error: syntax error, unexpected T_STRING, expecting '(' in C:\wamp\www\study_group\includes\functions.php on line 19 I got this error and this syntax is from 8 to 19th line. <?php ...
3
by: brkseven | last post by:
Looking for help with this Contact Form. The error is on line 1, but that' doesn't mean a lot, I think. In fact, a php syntax check passed it, but I was hoping for an easy syntax error, it looks...
3
by: SUNN | last post by:
Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in /Users/Sunn/Song/usersong/profile.php on line 113 This is the line 113 <script...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.