RE: StoreProc Driver question

2003-01-14 Thread Scott Brady
-- Original Message -- From: James Ang [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 13 Jan 2003 17:54:15 -0800 cfprocparam type=InOut cfsqltype=CF_SQL_TIMESTAMP dbvarname=start_date variable=start_date

RE: StoreProc Driver question

2003-01-14 Thread James Ang
] -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 7:30 AM To: CF-Talk Subject: RE: StoreProc Driver question -- Original Message -- From: James Ang [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 13

RE: StoreProc Driver question

2003-01-14 Thread Owens, Howard
Thanks for the help with the storedproc, guys ... I'm making progress, but now have a new problem ... Here's how my tags look now: cfstoredproc procedure=findDateRange datasource=#request.gldsn# returncode=yes cfprocparam type=Out

RE: StoreProc Driver question

2003-01-14 Thread Owens, Howard
DOH! Ignore my last question ... I figured it out. Needed to scope by output with ArchiveDates.start_date, etc. H. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: StoreProc Driver question

2003-01-13 Thread Owens, Howard
OK, follow up to my previous post ... I ran a test procedure that stripped it down to just a bare select query ... and it ran, so it's not a driver problem per se. There must be an error in my code ... if anybody has any tips to pass along ... here's my code: cfset request.start_date=1/1/80

RE: StoreProc Driver question

2003-01-13 Thread James Ang
MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 5:42 PM To: CF-Talk Subject: RE: StoreProc Driver question OK, follow up to my previous post ... I ran a test procedure that stripped it down to just