RE: works fine in access, but not cf

2003-09-14 Thread B.H. Forbes
never mind... it was the double quotes... changed ot single quotes and it works fine. -Original Message- From: pat forbes [mailto:[EMAIL PROTECTED] Sent: Sunday, September 14, 2003 10:30 PM To: CF-Talk Subject: works fine in access, but not cf I might have posted this twice...

RE: works fine in access, but not cf

2003-09-14 Thread B.H. Forbes
this thing is driving me nuts... my passed variable looks like this: cfoutput#passed_street_names#/cfoutput exact results: 'street 1,street 2,street 3,street 4' (exactly... one single quote before and after, one comma in between) SELECT accounts.accountid, accounts.streetname FROM accounts

RE: works fine in access, but not cf

2003-09-14 Thread B.H. Forbes
: Sunday, September 14, 2003 11:48 PM To: CF-Talk Subject: RE: works fine in access, but not cf -Original Message- From: B.H. Forbes [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 12:28 AM To: CF-Talk Subject: RE: works fine in access, but not cf this thing is driving me nuts

RE: Image upload en masse

2003-09-02 Thread B.H. Forbes
have him use ftp or is that too simple?? -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Monday, September 01, 2003 10:53 PM To: CF-Talk Subject: Image upload en masse Have a friend who's touring India for about 2 months later this year and is taking his digi

RE: Image upload en masse

2003-09-02 Thread B.H. Forbes
Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** -Original Message- From: B.H. Forbes [mailto:[EMAIL PROTECTED] Sent: Tuesday, 2 September 2003 1:36 PM To: CF-Talk Subject: RE: Image

RE: setting default page for 404 error

2003-08-30 Thread B.H. Forbes
i may be wrong (don't think so) but I don't think cf will catch a 404... there are a bazillion posts at MM of people trying to find out how to do it. -pat- -Original Message- From: Benjamin Rosenthal [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 5:39 PM To: CF-Talk Subject:

RE: output a # ?

2003-08-29 Thread B.H. Forbes
first find out what you are sending just before the redirect to pay-pal, put a: cfoutput#whatever_variable_you_want_to_see_#/cfoutput cfabort then play with the code until you get the value in the correct format. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent:

RE: output a # ?

2003-08-29 Thread B.H. Forbes
good idea... I forgot that that is something I always do when debugging things like that. add the two - to the output like this: (one in front, one in back) Just before the pay_pal code... add these lines. !- cfoutput-#whatever_variable_you_want_to_see_#-/cfoutput cfabort !- the

RE: Index.cfm problem again

2003-08-28 Thread B.H. Forbes
Not to be too picky, but I'd recommend that you use the Authenticated Users group, or better yet, just the IUSR_MACHINENAME account if possible - if you're not using Windows authentication - instead of Everyone. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax:

DATE conversion msAccess to mySQL

2003-08-28 Thread B.H. Forbes
My cold fusion forum software (using msAccess) has finally buckled under the heavy loads... I need to convert my existing msAccess data to another forum package that uses mySQL. I am able to convert all existing data except for any DATE field. All dates in the msAccess db are stored as Date/Time.

RE: CFHTTP to remotely submit form?

2003-08-28 Thread B.H. Forbes
i don't know if this is the answer to your question but... here is a code snippet that takes it's data from somewhere else, and the submits itself to yet a third program. html head titleError/TITLE /head body bgcolor=708090 onLoad=setTimeout('document.forms[0].submit();',50) form data, data, data

RE: DATE conversion msAccess to mySQL

2003-08-28 Thread B.H. Forbes
',1061550930) i may have the parameters a bit effed up, but you should get the picture. hth tony -Original Message- From: B.H. Forbes [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 8:14 PM To: CF-Talk Subject: DATE conversion msAccess to mySQL My cold fusion forum software (using