RE: Multiple Resultsets from a Stored Procedure
We use multiple resultsets (up to 4) with Sybase stored procedures and it works fine. We're using the native drivers not ODBC. I don't know about any CF preferences or limitations with them. Karen Jefferson VetCentric -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 3:20 PM To: CF-Talk Subject:RE: Multiple Resultsets from a Stored Procedure To be more specific -- I get the error: ODBC Error Code = S1002 (Invalid column number) [INTERSOLV][ODBC SQL Server driver]Number of bound columns exceeds the number of result columns. I have just discovered that there are no problems with the 3rd resultset, but the first two give me problems. Could this be within the stored procedure then? It runs fine through DBArtisan, but does Cold Fusion have preferences here? Thanks again. Lisa Haas -Original Message- From: Haas, Lisa Sent: Monday, January 08, 2001 2:19 PM To: '[EMAIL PROTECTED]' Subject: Multiple Resultsets from a Stored Procedure I have always had trouble in handling output from stored procedures with more than one result set. I am using the resultset attribute of cfprocresult with a Sybase stored procedure. Has anyone else run into this or come up with some reasons why this is such a problem? Thanks. Lisa Haas The Kennedy Center ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple Resultsets from a Stored Procedure
We use the Sybase11 native drivers and storedprocs with multiple resultsets without problems. There is nothing specific about returning multiple resultsets that I am aware of. The DSN settings are pretty routine. Karen Jefferson VetCentric -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 3:23 PM To: CF-Talk Subject:RE: Multiple Resultsets from a Stored Procedure Lisa I have a dozen stored procs with nothing between the selects (such as GO). Unless there is something specific about Sybase returning multiple resultsets to a client, you shouldn't need anything. But at least you have isolated the problem somewhat. I'm not sure what to try next - there are a few things about sybase drivers and such in CF help, but none seems to pertain to this particular problem. However, there are clearly more setting choices in setting up Sybase native drivers than with SQL Server. You might consider trying a new DSN in CF administrator with the native Sybase driver (as opposed to ODBC) and see if the problem goes away. Ideally, someone on this list uses Sybase and will chime in now. Mark That was a good idea. It is only returning the last resultset no matter which select statement is last. Is there something that needs to separate each select (begin/end statements, etc.) in order for CF to see it as a distinct resultset? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 9:51 AM To: CF-Talk Subject: RE: Multiple Resultsets from a Stored Procedure When you say that the third select is the one which returns the data, do you mean successfully, while the other two fail? Or that the first two selects do not return data because they are not supposed to? I assume it's the former. It sounds like if you run it with only one crprocresult tag, where resultset="3", it works fine. Which leads me to ask: Are the first two returning recordsets or variables? If you have always had trouble with multiple result sets, there's definitely a pattern there. Maybe you could switch two of the select statements in the stored proc (for testing). Call the third select when it's in different positions (and with a different number). If your problem has to do with only retrieving the last recordset, (i.e. the last one only works each time, whichever one is last), then this will at least focus your attention on that. Otherwise you can focus on the select statements. Mark I have all the variables in the correct order - the procedure will run fine - the errors come into play when I add the cfprocresult tag for resultset one and two. There are three main select statements in the procedure (the third being the simplest and the one which returns the data). They are not separated in the stored procedure (no begin/end or anything) - could this possibly be the problem? I have never managed to have a stored procedure with multiple resultsets work (with this particular sp writer) with the exception of the last returned resultset. Any ideas are greatly appreciated. Lisa Haas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:21 PM To: [EMAIL PROTECTED] Subject: RE: Multiple Resultsets from a Stored Procedure Yeah, that confuses me too. That's one for the list at large - although not necessarily relevant to the current problem. My guess is the Microsoft makes the odbc drivers, and that they're SQL Server compatible; Sybase and SQL Server have an intertwined history after all. Are there other pages you have where multiple resultsets work? Mark Also - I'm not sure why it says [INTERSOLV][ODBC SQL Server driver] since I am using a Sybase System 11 driver... Lisa -Original Message- From: Haas, Lisa Sent: Monday, January 08, 2001 3:55 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple Resultsets from a Stored Procedure Yes - see below: What I'm now finding is that the third resultset has no problem. The first two give me the error ODBC Error Code = S1002 (Invalid column number) Number of bound columns exceeds the number of result columns. cfstoredproc procedure="mcc_renewal_epatron" datasource="mcc" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@season" value="C2002" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@start_series" value="CJO" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@end_series" value="CJO" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@start_package" value="CJ2" cfprocparam type="in" cfsqltype="CF_SQL_CHAR" dbvarname="@end_package" value="CJ2" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@group" null
Re: Big companies using CF
http://www.bloomingdales.com - Original Message - From: Joe Sheble aka Wizaerd [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 04, 2000 9:18 PM Subject: Big companies using CF I know this is probably one of those discussions that turn up all the time on a mailing list such as this, and I apologize for bringing it up. I have a new IT Director starting at my company in the very near future who's a big Microsoft fan, and thinks there's nothing better than ASP and/or C# (which I believe hasn't even been released yet, no?). When I told him that CF has been around for a long time, and some really big companies use it, he doubted it. I told him Amazon.com was using it (was I right about this?). So anyway, I've agreed to compile a list of some of the bigger well known internet comapnies using it, and would like some assistance. What big time comapnies are using CF for their pages? thanx... Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.com = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ? short circuits my # !
Try wrapping it in URLEncodedFormat. Karen Jefferson [EMAIL PROTECTED] - Original Message - From: Anthony Israel-Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 12, 2000 7:22 PM Subject: ? short circuits my # ! I don't know if this is CF related or not, but if anyone can shed some light on it, it would be much appreciated. I have some pages that I would like to do inline linking (i.e. link to a lower part of a single page) OK, no problem add the appropriate a name=foo/a tag along with the reference a href="page.cfm#foolink/a. This works fine. The only problem is that I need to append a "?" and url variables. As soon as I add the "?" the inline links don't work. The link just takes the user to the top of the page.??? A few notes - the url variables are variables so the "#" is doubled up and the a tag has a cfoutput around it. So do url variables just kill this functionality or is there a workaround? Thanks in Advance ant -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFCONTENT used to work
This is a multi-part message in MIME format. --=_NextPart_000_00FB_01BFDB0A.A9683D00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've got several 4.0 CF servers (NT 4.0), and the same code will run on = only some of them. I'm displaying a table in Excel format using = CFCONTENT and application/excel, and cannot figure out why it won't work = on all of them. CFCONTENT is enabled on all servers. I searched thru = Allaire's KB already but nothing is ringing any bells. Anyone have any = clues on this? TIA!! Karen Jefferson [EMAIL PROTECTED] --=_NextPart_000_00FB_01BFDB0A.A9683D00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I've got several 4.0 CF servers (NT = 4.0), and the=20 same code will run on onlynbsp;some of them.nbsp; I'm displaying a = table in=20 Excel format using CFCONTENT and application/excel, and cannot figure = out why it=20 won't work on all of them. CFCONTENT is enabled on all servers. I = searched thru=20 Allaire's KB already but nothing is ringing any bells. Anyone have any = clues on=20 this? TIA!!/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Karen Jefferson/FONT/DIV DIVFONT face=3DArial size=3D2A=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/FONT= /DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_00FB_01BFDB0A.A9683D00-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFCONTENT used to work
Will doublecheck, but all were supposed to be configured with same SP ? - Original Message - From: Aaron Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 20, 2000 11:05 PM Subject: RE: CFCONTENT used to work Karen, Check your SP's on the boxes. SP 6 (and 6a) break CFCONTENT. Aaron -Original Message- From: Karen Jefferson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 20, 2000 7:56 PM To: [EMAIL PROTECTED] Subject: CFCONTENT used to work This is a multi-part message in MIME format. --=_NextPart_000_00FB_01BFDB0A.A9683D00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've got several 4.0 CF servers (NT 4.0), and the same code will run on = only some of them. I'm displaying a table in Excel format using = CFCONTENT and application/excel, and cannot figure out why it won't work = on all of them. CFCONTENT is enabled on all servers. I searched thru = Allaire's KB already but nothing is ringing any bells. Anyone have any = clues on this? TIA!! Karen Jefferson [EMAIL PROTECTED] --=_NextPart_000_00FB_01BFDB0A.A9683D00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I've got several 4.0 CF servers (NT = 4.0), and the=20 same code will run on onlynbsp;some of them.nbsp; I'm displaying a = table in=20 Excel format using CFCONTENT and application/excel, and cannot figure = out why it=20 won't work on all of them. CFCONTENT is enabled on all servers. I = searched thru=20 Allaire's KB already but nothing is ringing any bells. Anyone have any = clues on=20 this? TIA!!/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Karen Jefferson/FONT/DIV DIVFONT face=3DArial size=3D2A=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/FONT= /DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_00FB_01BFDB0A.A9683D00-- -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
