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 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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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
...
|
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...
|
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
...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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
| |