Re: escaping apostrophes for database insertion.
it works fine on my pc.
Pavan Kumar Puli
WebMaster/IT Manager
ABC Interactive
http://www.abcinteractive.com.au
- Original Message -
From: Sean Renet <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 07, 2000 11:18 AM
Subject: escaping apostrophes for database insertion.
> Lets say I have a variable called message.
>
> Message looks like:
>
>
>
> I want to input it into a database:
>
>
> insert into mytable(MESSAGE_MEM)
> values('#trim(Message)#')
>
>
>
> Because CF thinks the apostrophe in "can't" is closing the inserting
> variable I get this error.
> ODBC Error Code = 37000 (Syntax error or access violation)
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax
> near 't'.
>
>
>
> What is the trick for escaping the apostrophe?
>
>
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Archives - where are they now?
Hi everyone, I remember a few weeks/months ago someone posted the URL of the archives now that e-groups is full ... could someone repost that or email me directly with that link?? Thanks for your help, Chris -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: textarea
just insert in between# body# Pavan Kumar Puli WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au - Original Message - From: Gregg Kachel <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 28, 2000 3:48 AM Subject: textarea > > > Hi, I'm sort of a newbie with Cold fusion, so I'm probably doing some > simple mistake. I can't get my text to show up on a cfquery using > tag. Here is my code: > "#body#"> > Wierd thing is if I change it to an imput type =-text it works fine. So i > know it has to be something in my textarea code. If anyone can help please > do, thanks. > Gregg Kachel > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help!
hai, try to make use of cftransaction. Pavan Kumar Puli WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au - Original Message - From: aslam bajaria <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 21, 2000 7:54 AM Subject: Help! > I have come across a problem that has to be solved > today. > > I have a query that gets the list of all the MasterIds > > under some conditions: > > > select masterID > form MasterTable > where SignUpDate = #SignUpDate# > > > My goal is to delete all the masterids I get from this > query. Can someone tell me how to do it? > > Appreciate. > A.B. > > > > > __ > Do You Yahoo!? > Send instant messages with Yahoo! Messenger. > http://im.yahoo.com/ > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > - > This email server is running an evaluation copy of the MailShield anti- > spam software. Please contact your email administrator if you have any > questions about this message. MailShield product info: www.mailshield.com > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF syntax debate (kind of...)
it works Pavan Kumar Puli WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au - Original Message - From: Phil Labonte <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 18, 2000 11:41 PM Subject: CFIF syntax debate (kind of...) > This is a multi-part message in MIME format. > > --=_NextPart_000_0032_01BFD909.54A70BF0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > When using CFIF and using a variable from a form is it better to refer = > to the variable using ex:or can I use Var is not "")? Where Var is the variable in question that is from a = > form. > > What is the proper syntax? I looked in the Ben Forta CF book and there = > is no mention of this. > > Please help... > > > > --=_NextPart_000_0032_01BFD909.54A70BF0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > http-equiv=3DContent-Type> > > > > > When using CFIF and using a variable = > from a form is=20 > it better to refer to the variable using ex:not=20 > ""> or can I use the=20 > variable in question that is from a form. > > What is the proper syntax? I = > looked in the=20 > Ben Forta CF book and there is no mention of this. > > Please help... > > > > --=_NextPart_000_0032_01BFD909.54A70BF0-- > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL Server V's Oracle?
Hi Everyone, Does someone have any cool links to find out the differences between these two DB's...or maybe some good info that could explain the differences why i would go for one over the other?. Thanks. Chris Carpenter WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HELP to Browse CF locally without an internet connection ???
Hi Claude, In go to tools > internet options > connections > lan settings then, under advanced options, there should be a box that says : "...do not use proxy server for addresses beginning with... " in that box put your ip address : 127.0.0.1 and that should fix it.. Hope this Helps Chris Carpenter WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Using an App Variable to count unique page views?
HI everyone, i was about to set an application variable to count unique page views. Is this Advised? or could it have unforseen(to me) side effects? If this is a valid way of doing this, is there a way to run some code just as the application variable times out. i want to write the hits to a file or DB just before it timesout, so something like: ontimeout > do this... can this be done?? thanks, Chris Carpenter WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Big Problems!!
Thanks for all your help... i had the isp reboot my machine again, and then everything worked!!!. I feel really silly now, i stressed for about an hour, wrote the letter to the list, then thought of getting them to reboot again, and it all worked. Which is weird, considering i had already rebooted it once. anyway, thanks for your help, Chris Carpenter -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Big Problems!!
Hi Everyone, i am launching a site tomorrow and i have problems. I have cfserver 4.5.1, i uploaded an access2000 database and cf couldn't verify it. I have no special permissions set on it, no passwords yet, nothing. What could be making it not connect?? i thought "maybe i need the new mdac from MS" so i downloaded it, installed it,rebooted, and now PC Anywhere does not work, the access database still doesn't work either. would anyone know why mdac would stop PC Anywhere working? , or why a plain vanilla mdb which worked fine on the Dev server, fails to verify on my other server. the example mdb that was installed with CF works fine, i have checked the permissions given to it, and they seem the same as what i had given my DB. sorry if these questions are basic, but i have been thrown into the deep end here, and i don't want to drown. If you need more info, please ask and i will supply all i can. I am running nt4 sp6, cf4.5.1. MDAC 2.5 thanks Chris Carpenter. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
What to do with other Languages???
Hi, We have a large website about to be launched that can have members from all around the world. How do other developers (you guys) take input from people typing in other langauges?? do i need a translator? or are there specific CFTags for different langauges?? If the entries are inputed into the database, and our server does not have that language capability, can we later translate it?? but then how do we what language it was to start with. please help, this is very confusing NTServer 4, sp6.1 cfserver4.5.1 access200 database. thanks, Chris Carpenter WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cftransaction and cfserver 4.5.1 MY MISTAKE...
Thanks Xing, you were rightbut i dont remember that happening before the upgrade to CF 4.5, but i could be wrong. anyway, thanks again, now i know, i can just check the html... Chris Carpenter WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cftransaction and cfserver 4.5.1 MY MISTAKE...
Hello, Sorry i have worked for hours on end and days on end and i made a stupid mistake. (left out a period when scoping a variable) that was the error message..and wouldn't you know it...i found it about 5 seconds after sending the last email.. HOWEVER... the problem of not being able to read the error message still remains ... has anyone else seen this?? it happens a bit. i have the debugging sent to the ip address 127.0.0.1, and it only happens sometimes sorry for the previous post... thanks for reading... Chris Carpenter WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cftransaction and cfserver 4.5.1
Hello,
I previously (cfserver 4) used cftransaction and cflock to rollback any
errors when inserting a record and then selecting the last insert using
AX( ). eg:
INSERT INTO
Customers(Title,FirstName,LastName,Address,Suburb,State,PostCode,Country,Pho
ne,EmailAddress)
VALUES ('#form.Title#', '#form.FirstName#', '#Form.LastName#',
'#form.Address#', '#Form.Suburb#', '#form.State#', '#PostCode#',
'#form.Country#', '#form.Phone#', '#form.EmailAddress#')
SELECT MAX(CustomerID) as UserID
FROM Customers
I have upgraded to cfserver 4.5.1 and now it doesn't seem to work. the
insert works, (though it shouldn't if the select doesnt?) and then i get an
error, but cfserver doesn't show it. I have debugging on, but this is what i
get (look at bottom of message):
it is lopped off at the start i dont know what the error is...
So the problems are:
Cftransaction not working
Debugging error message cut off.
Something causing this error - maybe max() doesn't work anymorei
dont know...
could anyone help me...?
---start of error message---
site administrator that this error has occurred (be sure to include the
contents of this page in your message to the administrator).
Execution Time
32 milliseconds
Parameters
Form Fields:
ADDCUSTOMER=Add Customer
ADDRESS=24 cow street
COUNTRY=Australia
[EMAIL PROTECTED]
FIELDNAMES=TITLE,FIRSTNAME,LASTNAME,ADDRESS,SUBURB,POSTCODE,STATE,COUNTRY,PH
ONE,EMAILADDRESS,ADDCUSTOMER
FIRSTNAME=John
LASTNAME=Arachnid
PHONE=45678765
POSTCODE=3000
STATE=NSW
SUBURB=Arachnid
TITLE=Mr
Chris Carpenter
WebMaster/IT Manager
ABC Interactive
http://www.abcinteractive.com.au
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: IIS mailing lists
Hi, does anyone know of any good mailing lists for Nt servers running IIS 4 thanks, Chris Carpenter WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
My New ColdFusion server.....
Hello Everyone, The company i work for has just invested in a server and i need to install CF 4.5.1 on it in the next couple of days I was just hoping that some of you list members that do this sort of stuff all the time could maybe post a few tips or maybe just things to look out for or to install aswell, maybe some usefull URL's... you know, things that a first timer might overlook... thanks, Chris Carpenter WebMaster/IT Manager ABC Interactive http://www.abcinteractive.com.au -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL Help Please (in plain text...sorry...)
Hi,
I have a table with client details ('clients') that is related to another
table with category info ('category').
Now, each client could have more than 1 category in there CategoryID Field.
the user will be clicking on a link which will have one CategoryID as a URL
variable, and the state where they are searching eg:
categor
y
Below is my attempt, but this doesn't seem to work. (dont laugh, it is all i
could think of)
so the problem is that CategoryID could resolve to, for example: '1,5,7,8'
and the url parameter will always be one number, how do i write the SQL for
this...
SELECT ClientID,
BusinessName,
ContactName,
Address,
Suburb,
State,
PostCode,
PhoneNumber,
PhoneExt,
FaxNumber,
MobileNumber,
EmailAddress,
FunctionID,
CategoryID,
LogoPath,
IntroText
FROM Clients
WHERE '#Url.category#' IN (CategoryID) AND State = '#Url.State#'
I hope someone can help..
thanks,
Chris Carpenter
WebMaster/IT Manager
ABC Interactive
http://www.abcinteractive.com.au
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Sql Help Please....
This is a multi-part message in MIME format.
--=_NextPart_000_0033_01BF98D5.78A071A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I have a table with client details ('clients') that is related to =
another table with category info ('category').
Now, each client could have more than 1 category in there CategoryID =
Field.=20
the user will be clicking on a link which will have one CategoryID as a =
URL variable, and the state where they are searching eg:
#url.state#&Category=3D2=
">category
Below is my attempt, but this doesn't seem to work. (dont laugh, it is =
all i could think of)
so the problem is that CategoryID could resolve to, for example: =
'1,5,7,8' and the url parameter will always be one number, how do i =
write the SQL for this...
SELECT ClientID,
BusinessName,
ContactName,
Address,
Suburb,
State,
PostCode,
PhoneNumber,
PhoneExt,
FaxNumber,
MobileNumber,
EmailAddress,
FunctionID,
CategoryID,
LogoPath,
IntroText
FROM Clients
WHERE '#Url.category#' IN (CategoryID) AND State =3D '#Url.State#'
I hope someone can help..
thanks,
Chris Carpenter
WebMaster/IT Manager
ABC Interactive
http://www.abcinteractive.com.au
--=_NextPart_000_0033_01BF98D5.78A071A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I have a table with client details =
('clients') that=20
is related to another table with category info =
('category').
Now, each client could have more than 1 =
category in=20
there CategoryID Field.
the user will be clicking on a link =
which will have=20
one CategoryID as a URL variable, and the state where they are searching =
eg:
<A=20
HREF=3D"Display.cfm?state=3D<cfoutput>#url.state#</cfoutput>&=
amp;Category=3D2">category</a>
Below is my attempt, but this doesn't =
seem to work.=20
(dont laugh, it is all i could think of)
so the problem is that CategoryID could =
resolve to,=20
for example: '1,5,7,8' and the url parameter will always be one number, =
how do i=20
write the SQL for this...
<cfquery datasource=3D"#dsn#" =
Name=3D"Business"=20
cachedwithin=3D"#CreateTimeSpan(0,0,45,0)#"> SELECT=20
ClientID,
=20
=20
BusinessName,
=20
=20
ContactName,
=20
=
Address,
=20
=
Suburb,
=20
=
State,
=20
=
PostCode,
=20
=20
PhoneNumber,
=20
=
PhoneExt,
=20
=
FaxNumber,
=20
=20
MobileNumber,
=20
=20
EmailAddress,
=20
=20
FunctionID,
=20
=20
CategoryID,
=20
=
LogoPath,
=20
=
IntroText FROM=20
Clients WHERE '#Url.category#' IN (CategoryID) AND State =3D=20
'#Url.State#'
</cfquery>
I hope someone can =
help..
thanks,
Chris CarpenterWebMaster/IT =
ManagerABC=20
Interactivehttp://www.abcinteractive.com.au">http://www.abcinteractive.com.a=
u
--=_NextPart_000_0033_01BF98D5.78A071A0--
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
