Thanks to everybody, now my application is running.
- Original Message -
From: "Sergey Croitor" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, May 17, 2005 1:44 PM
Subject: Re: Database error
> RC> Thanks, I'm trying to change t
Thanks, PreserveSingleQuotes() is working.
- Original Message -
From: "Sergey Croitor" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, May 17, 2005 1:44 PM
Subject: Re: Database error
> RC> Thanks, I'm trying to change the code using nested que
RC> Thanks, I'm trying to change the code using nested queries.
try PreserveSingleQuotes at first as Jochem advised you:
UPDATE #qry_getSpcListInfo.PrimEntity#
SET #PreserveSingleQuotes(setliststr)#
WHERE #whereclause#
--
Sergey
~
Thanks, I'm trying to change the code using nested queries.
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, May 17, 2005 12:39 PM
Subject: Re: Database error
> Rajani Chandra wrote:
> > Yesterda
> Yesterday i try cfqueryparam for simple query it works, but
> I'm not getting how to use cfqueryparam for my code because
> I'm storing all the fieldnames and values in one single variable
> (SETLISTSTR) and directly passing that variable to query.
>
>
>
>
> UPDATE #qry_getSpcListInfo
it works in SQL Query Analyzer.
- Original Message -
From: "Sergey Croitor" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, May 17, 2005 12:50 PM
Subject: Re: Database error
> hi,
>
> Localize the error.
> Copy this final query into SQL Query An
hi,
Localize the error.
Copy this final query into SQL Query Analyzer or SQL Enterprise
Manager and check if it works there.
Does it work there?
RC> Variable Query is displayling like this in browser:
RC> UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 ,
RC> Person.LstDate =
Rajani Chandra wrote:
> Yesterday i try cfqueryparam for simple query it works, but I'm not getting
> how to use cfqueryparam for my code because I'm storing all the fieldnames
> and values in one single variable (SETLISTSTR) and directly passing that
> variable to query.
>
>
>
>
> UPDATE
PrimEntity#
SET #setliststr#
WHERE #whereclause#
I don't have any idea how to use cfqueryparam for this code, so plz help me.
Thanks.
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, May 17, 2005 12:15
Rajani Chandra wrote:
> No, I'm just using single quote, this is my code.
>
>
>
>
>
>
Use cfqueryparam.
Jochem
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://ww
Thanks.
- Original Message -
From: "Paul Vernon" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, May 17, 2005 11:47 AM
Subject: RE: Database error
> This should fix it
>
>
>
>
>
>
>
> Paul
>
>
>
This should fix it
Paul
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion
No, I'm just using single quote, this is my code.
I'm passing that variable in query. Thanks.
- Original Message -
From: "Nick de Voil" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, May 17, 2005 11:35 AM
Subject: Re: Databas
> I'm getting this error, whenever I'm trying to update the database, I'm
using CFMX 7, this is my query
>
> UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 ,
Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta =
'M' WHERE Person.Objectno = 2005
Are you usi
it is varchar, that's why I put it in single quotes.
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, May 17, 2005 11:21 AM
Subject: Re: Database error
> what datatype is the column?
>
> tony
>
>
what datatype is the column?
tony
On 5/17/05, Rajani Chandra <[EMAIL PROTECTED]> wrote:
> I'm getting this error, whenever I'm trying to update the database, I'm using
> CFMX 7, this is my query
>
> UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 ,
> Person.lstno = 2005042
CTED]>
Sent: Tuesday, June 01, 2004 11:14 AM
Subject: RE: database error when using cfqueryparam
> Take out the "bio_f = " before the CFQUERYPARAM tag. You're already
> specifying the column name in the first parenthesized list, so you don't
> need it in the
hehe thanks guys for ALL the answers hehe
- Original Message -
From: Daniel Farmer
To: CF-Talk
Sent: Tuesday, June 01, 2004 2:08 PM
Subject: database error when using cfqueryparam
Having trouble figuring out what is causing this error
ERROR
MERANT][ODBC SQL Ser
Take out the "bio_f = " before the CFQUERYPARAM tag. You're already
specifying the column name in the first parenthesized list, so you don't
need it in the value list.
Cheers,
banreyb
> -Original Message-
> From: Daniel Farmer [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 01, 2004 11:
Single quotes around the cfqueryparam?
bio_f = ''
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> Having trouble figuring out what is causing this error
>
> ERROR
>
> MERANT][ODBC SQL Server Driver][SQL Server]The name 'bio_f'
> is not permitted in this context. Only constants,
> expressions, or variables allowed here. Column names are not
> permitted.
>
> ...
> VALUES (
>
Remove "bio_f =" from your value list.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
bio_f is the field name and should ONLY be in the field listyou use bio_f = in UPDATEs ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia
t; Sent: Tuesday, May 04, 2004 5:35 PM
> To: CF-Talk
> Subject: RE: Database error messages
>
> Hey Barney can you put them on a web server and give us the
> URL? This will
> save you on all the sending stuff.
>
> TK
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Barney,
I'd love that error handling code. I'll give you a plug on my blog.
-mark
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 5:48 PM
To: CF-Talk
Subject: RE: Database error messages
Whoops, no attachements
04 5:35 PM
> To: CF-Talk
> Subject: RE: Database error messages
>
> Hey Barney can you put them on a web server and give us the
> URL? This will
> save you on all the sending stuff.
>
> TK
> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECT
Hey Barney can you put them on a web server and give us the URL? This will
save you on all the sending stuff.
TK
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 6:48 PM
To: CF-Talk
Subject: RE: Database error messages
Whoops, no
Pls send me a copy
thx
Dick
On May 4, 2004, at 3:47 PM, Barney Boisvert wrote:
> Whoops, no attachements on cf-talk. That must be cfczone that lets
> them
> through. I can't post it online right now, but if anyone's
> interested,
> email me off list, and I'll shoot you the archive.
>
> C
Whoops, no attachements on cf-talk. That must be cfczone that lets them
through. I can't post it online right now, but if anyone's interested,
email me off list, and I'll shoot you the archive.
Cheers,
barneyb
> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECTED]
> Se
> I don't understand the following MS SQL error. Both columns for
> the primary and foreign key are varchar(20). I don't know how to
> fix this error because
> I don't even know what it means as it is the first time for this one. Any
> help?
>
> - Unable to create relationship 'FK_TrainingTranslat
Sebastian,
SQL Server has an 8060 byte limit on the size of a row, excluding text,
image and some other fields that are stored in separate pages. You might
want to either reduce the size of some of the datatypes in the table, if
possible, or break the table up into smaller entities.
HTH,
Seva Pe
Sebastian,
If I remember my SQL Server details correctly...this is a limitation of SQL
Server in table field name space. You cannot exceed 8060 characters
(actually 8032 with header space) for your field names in a single table.
For example, a table with two fields (FirstName, LastName) has used 1
32 matches
Mail list logo