Oi... having an internet connection is a security risk.
I locked my keys in the car the other night. I had to make a simple
tool and slid it down between the body of the car and the top of the
door, to hit the electric lock button. It took less than 30 seconds to
steal my own car. But it was
Might I add that in CF 7 the complete ColdFusion Admin has an API so
you could make datasources dyhnmically that way...I would guess with a
little investigation you could figure out how to do simular in MX 6...
Adam H
On Sun, 6 Mar 2005 12:35:19 -0600, Jared Rypka-Hauer - CMG, LLC
[EMAIL
I have a couple of applications where I want to update two database
servers simultaneously. I have just set up a datasource for each
server on my CFserver, and run the update query twice - once with each
datasource name. No need for connect strings.
It breaks if the remote server isnt available
Add the server as a datasource.
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 2:46
To: CF-Talk
Subject: CFQUERY accessing MS SQL DB on another CF server
MX 6.1
In some of the earlier versions you could query a db on other servers around
the
Well, hard coding your SQL username password is a security risk and IMHO
bad practice.
You should let the CFAdmin handle that for you.
Warmest Regards,
Phillip B. Holmes
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 06, 2005 12:46 AM
To: CF-Talk
CFAdmin's instructions are to provide the following ConnectionString. It is
that way
or no way.
ConnectionString = DRIVER=SQL Server;SERVER={ipaddress};UID={username};
PWD={password};APP=;DATABASE={database}
I can't figure out where to put it?
Security is not an issue in this case. Some public
IMO hard-coding a database username/password in your app is only a
security risk if the wrong people already have access to your file
system, in which case you likely have bigger issues than the database
username in your application code.
Many shared hosting providers don't include the username /
Well, you can't do it in the cfquery tag, so it's no way.
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 3:13
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
CFAdmin's instructions are to provide the following
Unless they are using sandboxing on CF Enterprise, like ay decent ISP
should.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 3:23
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
[snip]
Many shared hosting
hi - just wondering of I can include server specific
SQL in a cfquery tag? I want to use some of MySQL's
row locking features with an InnoDB table.
ColdFusion will take whatever you pass in and send it off to the database
driver selected for your datasource. Assuming you're not using
the only changes CF will make is to add a semicolon to the
end of the query,
Plus eventually escape single quotes in strings.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this
CREATE TABLE HartGraph (
IDNumb int NOT NULL default 0,
HorizMark int NOT NULL default 0,
)
the above CREATE TABLE statement will also create you a couple of
default contraints, using automatically generated names. In effect the
above query was run as:
CREATE TABLE
Nick Baker wrote:
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]The object
'DF__HartGrap__Horiz__123EB7A3' is dependent on column 'HorizMark'.
You probably have an index or foreign key on the field that you
need to
At 04:35 PM 2/9/2005, you wrote:
Nick Baker wrote:
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]The object
'DF__HartGrap__Horiz__123EB7A3' is dependent on column 'HorizMark'.
You probably have an index or foreign
I don't see anything like that.
Do you have any diagrams with lines connecting the tables? Those lines
usually create constraints that would cause fields to throw errors if you
try to drop them. Also, IIRC, when you change the field type in SQL Server
it actually creates a new temporary
MS SQL
CFMX 6.1
How do you limit the score of info returned?
or
The equivalent of MySQL
LIMIT #StartRow#, #NumberRows#
To get the first 5 rows:
SELECT TOP 5 ...
To get the second 5 rows:
SELECT TOP 5 ...
FROM ...
WHERE field NOT IN (SELECT TOP 5 ...)
Dave Watts, CTO, Fig Leaf
Select Distinct *
INTO #temp
From mytable
truncate TABLE my table
Insert into myTable
Select *
From #temp
or thats the psuedo code for it...not sure the exact syntax is right
Adam H
On Fri, 28 Jan 2005 08:14:14 -0800 (PST), Discover Antartica
[EMAIL PROTECTED] wrote:
Does anyone know
The Proc is looking for a like within the string '[EMAIL PROTECTED]' - you
will need
to do the following:
Excellent, that works perfectly, thanks!
I just figured out full text searching last night, and think I'm going to
create a catalog for this db and give it a shot.
Thanks again for your
The Proc is looking for a like within the string '[EMAIL PROTECTED]' - you will
need
to do the following:
SELECT tblprodmodelcodes.prodmodelcode,
tblprodmodelcodes.prodmodeltitle,tblprodmodelcodes.prodcategory,
tblprodmodelcodes.prodsellprice,
(SELECT TOP 1 imagename
FROM tblproductimages
To: CF-Talk
Subject: Re: CFQUERY --- Stored Procedure
The Proc is looking for a like within the string '[EMAIL PROTECTED]' - you
will need
to do the following:
Excellent, that works perfectly, thanks!
I just figured out full text searching last night, and think I'm going to
create a catalog
Pascal Peters wrote:
This is intended behavior: any CF string variable within a cfquery
will escape (double) single quotes. I think it has always been like this
(at least since CF4).
OK, thanks for clearing that up.
This would throw an error if single quotes weren't escaped. This is
purely
isn't that the common thing that PreserveSingleQuotes() is used for?
Doug
- Original Message -
From: Damien McKenna [EMAIL PROTECTED]
Date: Fri, 17 Sep 2004 16:54:06 -0400
Subject: cfquery still breaking apostrophies in CFMX 6.1 updater?
To: CF-Talk [EMAIL PROTECTED]
I've just noticed
This is intended behavior: any CF string variable within a cfquery
will escape (double) single quotes. I think it has always been like this
(at least since CF4). This is implemented this way so you don't have to
worry about single quotes when you write something like:
cfquery...
...
WHERE column
hi joe,
i'm just guessing, but maybe MX reads the datasources at the begin of every request, so that it does not know your datasource you just created.
maybe if you use cflocation you would have more luck ...
cheers gert
- Original Message -
From: joe velez
To: CF-Talk
Sent: Tuesday,
hmm i dunno .. actually i managed to get it to work some of the time HEHE .. then i found a java sleep tag to use .. and that worked every time except when i refreshed the page 5 times real quick, then it gave me an error that either the db didnt exist, or the table didnt exist.
i guess i coudl
I guess this is what you need
http://cflib.org/udf.cfm?ID=686
- Original Message -
From: Christian Watt [EMAIL PROTECTED]
Date: Tue, 31 Aug 2004 10:21:43 -0500
Subject: CFQuery
To: CF-Talk [EMAIL PROTECTED]
I know you can return the execution time of a query, but how do you
return what
: Tuesday, August 31, 2004 10:37 AM
To: CF-Talk
Subject: Re: CFQuery
I guess this is what you need
http://cflib.org/udf.cfm?ID=686
- Original Message -
From: Christian Watt [EMAIL PROTECTED]
Date: Tue, 31 Aug 2004 10:21:43 -0500
Subject: CFQuery
To: CF-Talk [EMAIL PROTECTED]
I
Message -
From: Christian Watt [EMAIL PROTECTED]
Date: Tue, 31 Aug 2004 12:00:39 -0500
Subject: RE: CFQuery
To: CF-Talk [EMAIL PROTECTED]
Reply, not quite, this only works when an error has occurred.I would
like to do this even if an error has not occurred.
cfquery name=somequery
Select
- Original Message -
From: Qasim Rasheed [EMAIL PROTECTED]
Date: Tue, 31 Aug 2004 13:10:30 -0400
Subject: Re: CFQuery
To: CF-Talk [EMAIL PROTECTED]
As far as I can tell after looking at the UDF, it doesn't require an
error to occur before it returns the sql statement. the only
requirement I
Hello all,
In my page, clicking on a name brings up another window where you can
edit their information (their address is shown below their name).The
addressID for each address is also stored in a variable (addressIDList).
Clicking on a button gets the the current information from the database
anyway.
Christian
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 12:11 PM
To: CF-Talk
Subject: Re: CFQuery
As far as I can tell after looking at the UDF, it doesn't
require an
error to occur before it returns the sql statement
so why is debugging being enabled on a production machine bad?
it takes up valuable time slices:)
Doug
- Original Message -
From: Christian Watt [EMAIL PROTECTED]
Date: Tue, 31 Aug 2004 13:34:52 -0500
Subject: RE: CFQuery
To: CF-Talk [EMAIL PROTECTED]
Yes, you are correct
Yes, you are correct, but the requesting IPAddress has to
be in the
debugging IP Addresses.otherwise IsDebugMode returns
false.This
brings up an interesting question though, if my ip is not
in the list
then I don't get debug information and debug mode is
turned off, so why
is debugging
I have been reading in many places to increase performance,
increate the BLOCKFACTOR of queries to 100.If I have a
query that generally returns 5 rows should a blockfactor of
100 benefit, hurt, or not affect performance.
I have tried using the blockfactor in the past by going
through
This brings up an interesting question though, if my ip is not
in the list then I don't get debug information and debug mode
is turned off, so why is debugging being enabled on a production
machine bad?
My understanding is that simply gathering debug statistics incurs a
performance penalty,
If debugging is turned on in the admin debuging routines are ALWAYS
run. IsDebugMode() returns for the specific instance weather YOU will
see degubbing or not. Debuging from my expeince does use a good bit of
processing time.
However that asside somehow the debugging information is pulling
the
If you are using CFMX you can get at the query information
using the service factory.I posted a function on my
blog (http://blog.mxconsulting.com). I'm sorry if someone
has already mentioned this - it's been around for a
while and resurfaces every few months. I think I originally got
it from one
so why is debugging being enabled on a production machine
bad?
it takes up valuable time slices:)
Doug
Personally I find time difficult to slice ... I can never seem to find
a knife sharp enough to penetrate its fabric. :)
s. isaac dealey954.927.5117
new epoch : isn't it time for a
Subject: RE: CFQuery
If you are using CFMX you can get at the query information
using the service factory.I posted a function on my
blog (http://blog.mxconsulting.com). I'm sorry if someone
has already mentioned this - it's been around for a
while and resurfaces every few months. I think I
Ah.. is that dilemna - sorry, I misread.
-Original Message-
From: Christian Watt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 3:55 PM
To: CF-Talk
Subject: RE: CFQuery
The way that Forta wrote a UDF though implies that you have to have
debugging enable to use
If you are trying to pull it the way I did in that UDF, then yes, debugging
must be on. I have not yet found a way to get this without debugging
enabled.
--- Ben
_
From: Christian Watt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 4:55 PM
To: CF-Talk
Subject: RE: CFQuery
Thanks Ben, that is what I was afraid of.
Christian
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 4:09 PM
To: CF-Talk
Subject: RE: CFQuery
If you are trying to pull it the way I did in that UDF, then
yes, debugging
must be on. I
Subject: Re: CFQuery
so why is debugging being enabled on a production machine
bad?
it takes up valuable time slices:)
Doug
Personally I find time difficult to slice ... I can never seem
to find
a knife sharp enough to penetrate its fabric. :)
s. isaac dealey954.927.5117
new
Let me add to this one and see if anyone knows how to
output the
parameters passed to a stored proc as well.Without
having debuggin
enabled also.
Use a function or custom tag to call all your stored procedures and
store the arguments or attributes for later use. It would be pretty
easy to
you can't catch this type of issue.Look at tuning the queries and code on the page to run faster.Also look at cfsetting requesttimeout= if needed.
Doug
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 5:03 PM
To: CF-Talk
Subject: CFQUERY Timeout
cftry
cfquery
x
x
/cfquery
cfcatch type=database
Your error routine here
/cfcatch
/cftry
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 5:03 PM
To: CF-Talk
Subject: CFQUERY Timeout
Hello All,
My host has issues from time to time I get
Ah... so the truth comes out - as the Gestapo said to the grandfather clock ... ve haf vays to make you tock...
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 7:52 AM
To: CF-Talk
Subject: RE: CFQUERY - MySQL Chicken and Egg
I'm a liar, I
Just like with any other DBMS, you'll have to create a database through the
database's native interface, not via CF.With MySQL, that's the `mysql`
command line tool.Call it like this:
Mysql -u username -p [ -h hostname ]
The -p will make it prompt for your password, and the -h will allow you to
.
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 4:16 AM
To: CF-Talk
Subject: RE: CFQUERY - MySQL Chicken and Egg
Just like with any other DBMS, you'll have to create a database through the
database's native interface, not via CF.With MySQL, that's
up a DNS to
it, I didn't want to confuse the issue.
Cheers,
barneyb
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 5:43 AM
To: CF-Talk
Subject: RE: CFQUERY - MySQL Chicken and Egg
Not exactly true that you have to use
Why would an error occur in a perfectly valid query? You can simply have
an alternate display if the query is empty:
cfifPropertyDetails.recordCount
!--- show table ---
cfelse
!--- alternate display ---
/cfif
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: dinsdag
I have this query:
CFQUERY NAME=PropertyDetails datasource=020
SELECT PropertyDataID, PropertyAgentID,
PropertyDataAgentReference, PropertyDataFlatNumberHouseName,
PropertyDataStreetNumber, PropertyDataStreetName,
PropertyDataVillageTown, PropertyDataCountyState,
Thanks Philip and Pascal,
I've fixed it up so now I have a cfquery param on url.propertydataid (making sure it's only an integer which is processed) and also checked if the recordcount is gt 0 then display the form otherwise display a message saying that You don't have user rights to edit this
From: Stuart Kidd
When I get some spare time i'm going to go through all my
code and put cfqueryparams everywhere.One thing I don't
understand is though, if i put a cfqueryparam on
PropertyDataVillageTown for instance, this will be any type
of string inputed therefore couldn't a hacker
Thanks for that Philip, that gives me a better understanding.
But I suppose trapping for wrong datatypes outside of the query opens a whole new can of worms?...
-- Original Message --
From: Philip Arnold [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Stuart Kidd
Thanks for that Philip, that gives me a better understanding.
No problems, glad to help g
But I suppose trapping for wrong datatypes outside of the
query opens a whole new can of worms?...
It throws an error, so you'd have to do a CFTRY, CFCATCH to check that
the error
ohhh :) here is the code I saw...
!---cftry ---
CFSCRIPT
/* This will open Word if running locally */
objWord.Visible = true;
/* This returns the 'Documents' collection of the Word object */
objDoc = objWord.Documents;
/* Open the document */
newDoc = objDoc.open(fileName);
/* Send the
You can make it a stored procedure in SQL server or at least use cfqueryparam tag. How often does the category data change and how recent results do you need? If it doesn't need to be the newest result set consider caching the query data (you may even run a process every so often to populate a
Off the top of my head I would say run the query for each letter and
cache it then use the cached copy.This depends, of course, on:
1) How much data will be retrieved?To much to cache?If so perhaps
you could construct temp tables on the DB with the letter queries.
Lacking that you might also
Because a View is guaranteed correct, otherwise SQL Server wouldn't
allow it to be created, then the SQL is pre-compiled, while sending a
fresh bit of SQL to the server has to be compiled at that time
Theoretically the View should be faster - but YMMV!
The only way to guarantee what your
select PKID
from myTable
where name not in (#attributes.myList#)
that's only if the values of attributes.myList is really a list.
you didn't need the 's (apostrophes) that's all.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
Let's say I have a list:
cfset attributes.myList = John, Amy
How can I do a query that would take that list and do a not in?
cfquery name=blah ...
select PKID
from myTable
where name not in ('#attributes.myList#')
/cfquery
Check the ListQualify() function inside the docs
cfquery name=blah ...
select PKID
from myTable
where name not in (cfquery param value=#attributes.myList# cfsqltype=cf_sql_varchar list=yes)
/cfquery
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
something like
cfquery name=blah ...
select PKID
from myTable
where name not in (CFQUERYPARAM VALUE=#attributes.myList#
CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes)
/cfquery
altho make sure that there is something in the list... an empty list will
throw an error
HTH
-Original Message-
oi Won!!
it's probably not working because each item in the list is not single quoted..
cfset attributes.myList = 'John','Amy' that would work, no?
--
Tuesday, October 7, 2003, 11:05:32 AM, you wrote:
WL Hello,
WL Let's say I have a list:
WL cfset
Won,
On 10/7/2003 at 11:05, you wrote:
WL cfset attributes.myList = John, Amy
WL How can I do a query that would take that list and do a not in?
WL cfquery name=blah ...
WLselect PKID
WLfrom myTable
WLwhere name not in ('#attributes.myList#')
WL /cfquery
WL (This codes doesn't work)
WL CF
We got a winner.
Thanks.
Thanks to everyone else that helped as well.
At 04:13 PM 10/7/2003 +0100, you wrote:
something like
cfquery name=blah ...
select PKID
from myTable
where name not in (CFQUERYPARAM VALUE=#attributes.myList#
CFSQLTYPE=CF_SQL_VARCHAR LIST=Yes)
/cfquery
altho make sure
and the winner was?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 11:23 AM
To: CF-Talk
Subject: RE: cfquery + list
We got
: Won Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 11:23 AM
To: CF-Talk
Subject: RE: cfquery + list
We got a winner.
Thanks.
Thanks to everyone else that helped as well.
At 04:13 PM 10/7/2003 +0100, you wrote:
something like
cfquery name=blah ...
select PKID
from myTable
Subject: RE: cfquery + list
We got a winner.
Thanks.
Thanks to everyone else that helped as well.
At 04:13 PM 10/7/2003 +0100, you wrote:
something like
cfquery name=blah ...
select PKID
from myTable
where name not in (CFQUERYPARAM VALUE=#attributes.myList#
CFSQLTYPE=CF_SQL_VARCHAR LIST
.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 11:33 AM
To: CF-Talk
Subject: RE: cfquery + list
Misunderstood what your email was asking.
The CFQUERYPARAM VALUE=#attributes.myList#
CFSQLTYPE
Hi,
If I put a cfquery in my application.cfm off the main root of my website will that query only run once or everytime a file is accessed in that directory?
I need to do a query the first time the site is accessed and then not again unless the browser is closed and the site accessed again.
everytime, unless you set a variable based on some value that is
returned from
the results of your query and then you check for its existence.
make sense?
tony
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 11:05 AM
To: CF-Talk
Subject: re
cfloop list=#ListLoop# Index=Line Delimiters=#strCR#
/cfloop
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137484
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription:
Hi,
Below is my INSERT inside of a loop. Everything is working just fine. I would like to
know how I can exclude certain var in my SQL statement.
If the var is equal to something then don't insert. Like a WHERE?
WHERE var NEQ 'xxx' OR 'yyy' OR 'zzz'
How can I add that sort of syntax to my
-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 18 September 2003 15:36
To: CF-Talk
Subject: re cfquery INSERT into SQL database
Hi,
Below is my INSERT inside of a loop. Everything is working just fine. I
would like to know how I can exclude certain var in my SQL statement.
If the var is equal
cfif ;-)
Michael Traher
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 18 September 2003 15:36
To: CF-Talk
Subject: re cfquery INSERT into SQL database
Hi,
Below is my INSERT inside of a loop. Everything is working just fine. I
would like to know how I can exclude
. this also save you having to
hard code each prohibited word, and also will allow in definate expansion,
Jason Lees
Development Team Leader
National Express.
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 18 September 2003 15:36
To: CF-Talk
Subject: re cfquery
To: CF-Talk
Subject: Re: cfquery??
So when i am coding what should I use?
Or is it going to be that all you need to do is name and datasource?
Dave Watts wrote:
So, if cfquery is a deprecated tag, what should we be using
in its place??
Anyone heard anything about this?
http
Message-
From: Gary Hotko [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 3:59 PM
To: CF-Talk
Subject: Re: cfquery??
So when i am coding what should I use?
Or is it going to be that all you need to do is name and datasource?
Dave Watts wrote:
So, if cfquery is a deprecated
work as an
analyst/programmer.
-Original Message-
From: Gary Hotko [mailto:[EMAIL PROTECTED]
Sent: Friday, 5 September 2003 4:13 PM
To: CF-Talk
Subject: Re: cfquery??
Does anyone know when Macromedia posted the depreciation (a date would
help?)
Tony Weeg wrote:
i can answer this one
Sweet! I never knew you could add more of those. I've only been using studio
for what...5 years? Sheesh.
- Original Message -
From: Tyler Silcox [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 1:42 PM
Subject: RE: cfquery syntax
Yep, that's (sorta
Tyler,
Snippets as well - you can define a beginning and ending, highlight a block
of code and the bracket it in.
-Mark
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 1:42 PM
To: CF-Talk
Subject: RE: cfquery syntax
Yep, that's (sorta
So when i am coding what should I use?
Or is it going to be that all you need to do is name
and datasource?
Usually, that's all you've ever needed anyway - name and datasource.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
Hi,
What's wrong with the below syntax? I think the single quotes around the commalist
is throwing it for a loop?
How can I get around this? If I use double quotes I'll run into the same problem
around the ListGetAt... code.
cfquery name=Insert datasource=prefs
UPDATE tblProfiles
I checked the database and there seems to be something wrong with the cfqueryparam
because when I check the fields using SQL Query Analyzer there are question
marks ? in the fields which I think is an error trying to update the fields?
Do I need the cfqueryparam?
On Thu, 04 Sep 2003 07:55:24
I checked the database and there seems to be something
wrong with the cfqueryparam because when I check the
fields using SQL Query Analyzer there are question marks
? in the fields which I think is an error trying to
update the fields?
If you look at debug output for an SQL statement
I'm getting a little further but now I get this error. What does this mean?
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from
data type text to data type nvarchar, table
: Bushy [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 8:52 AM
To: CF-Talk
Subject: RE: cfquery syntax
I'm getting a little further but now I get this error. What does this
mean?
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft
, 2003 7:55 AM
To: CF-Talk
Subject: re: cfquery syntax
Hi,
What's wrong with the below syntax? I think the single quotes around the
commalist is throwing it for a loop? How can I get around this? If I
use double quotes I'll run into the same problem around the
ListGetAt... code.
cfquery
Speaking of this.. can someone clear this up for me?
I thought I read somewhere that you can not use cached
queries when you use cfqueryparam.
Is this true?
Thanks,
Dave Fafard
snip
Do I need the cfqueryparam?
It's not absolutely necessary, but it is a really good idea to use it
PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 8:52 AM
To: CF-Talk
Subject: RE: cfquery syntax
I'm getting a little further but now I get this error. What does this
mean
Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: donderdag 4 september 2003 14:06
To: CF-Talk
Subject: re: cfquery syntax
I checked the database and there seems to be something wrong with the
cfqueryparam because when I check the fields using SQL Query Analyzer
there are question
marks
: Bushy [mailto:[EMAIL PROTECTED]
Sent: donderdag 4 september 2003 13:55
To: CF-Talk
Subject: re: cfquery syntax
Hi,
What's wrong with the below syntax? I think the single quotes around the
commalist is throwing it for a loop? How can I get around this? If I
use double quotes I'll run
It's true in cf 5.0. Not sure about newer versions.
-Deanna
- Original Message -
From: David Fafard [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 8:06 AM
Subject: Re: cfquery syntax
Speaking of this.. can someone clear this up for me?
I thought I
. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 9:08 AM
To: CF-Talk
Subject: RE: cfquery syntax
On Thu, 4 Sep 2003 09:02:14 -0400
Peters [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 8:14 AM
To: CF-Talk
Subject: RE: cfquery syntax
You see the ? BECAUSE of the cfqueryparam and this is not an error. It
is just a placeholder for the value. And you should ALWAYS use
cfqueryparam The only exception you can make
Yes, it is
-Original Message-
From: David Fafard [mailto:[EMAIL PROTECTED]
Sent: donderdag 4 september 2003 15:07
To: CF-Talk
Subject: Re: cfquery syntax
Speaking of this.. can someone clear this up for me?
I thought I read somewhere that you can not use cached
queries when you use
september 2003 15:16
To: CF-Talk
Subject: RE: cfquery syntax
why should one ALWAYS use cfqueryparam?
I havent, EVER and have many apps, on many servers
and no problemsjust wondrin'
tony weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 9:08 AM
To: CF-Talk
Subject: RE: cfquery syntax
On Thu, 4 Sep 2003 09:02:14 -0400, Tony Weeg wrote:
what does your query look like? I usually get that error
when I try to do an insert
301 - 400 of 593 matches
Mail list logo