473,387 Members | 3,787 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Getting the values out of the Recordset

I have a proc that I am running on the website. It pulls out tracking data based on order number entered. Here is the query sent for the recordset:

Expand|Select|Wrap|Line Numbers
  1. DECLARE @FinalTracking varchar(50) DECLARE @FinalShipType varchar(50) EXEC FindCustomerTracking 111020355, 37, @TrackingNumber = @FinalTracking OUTPUT, @ShippingType = @FinalShipType OUTPUT
It brings back that data, I get it in the recordset. Now how do I use the data? My first guess was "response.write rs("@ShippingType")", seconded being "response.write rs("ShippingType"). Neither work. So once I put the data in the record set what can I use to get it out? Or what changes can I make to make it possible to get the data out?
Aug 22 '07 #1
2 1197
jhardman
3,406 Expert 2GB
what version of ASP is this, and what is your development platform?

Jared
Aug 23 '07 #2
ilearneditonline
130 Expert 100+
I have a proc that I am running on the website. It pulls out tracking data based on order number entered. Here is the query sent for the recordset:

Expand|Select|Wrap|Line Numbers
  1. DECLARE @FinalTracking varchar(50) DECLARE @FinalShipType varchar(50) EXEC FindCustomerTracking 111020355, 37, @TrackingNumber = @FinalTracking OUTPUT, @ShippingType = @FinalShipType OUTPUT
It brings back that data, I get it in the recordset. Now how do I use the data? My first guess was "response.write rs("@ShippingType")", seconded being "response.write rs("ShippingType"). Neither work. So once I put the data in the record set what can I use to get it out? Or what changes can I make to make it possible to get the data out?
Looks like SQL code to me.But you are not showing the actual select statement. TO look through the recordset it would be something like...
Expand|Select|Wrap|Line Numbers
  1. rs.Fields.Item("exactfieldnamereturned").value
Assuming this is SQL, what does your resultset look like in query analyzer?
Aug 23 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Vipul Pathak | last post by:
Hello Friends ! I have the Following Code, that Executes a Stored Procedure and Attempt to read a Returned Integer Value from the StoredProc. But It gives Error ... ADODB.Command (0x800A0BB9)...
6
by: Modest Marsupial | last post by:
What is the DAO method of allowing a recordset to have null values? Thanks, marie
7
by: Matt | last post by:
Is there a way to put my class vals to arrays ! RecordSet Track1 = new RecordSet("It aint fear",1); RecordSet Track2 = new RecordSet("Gotta go",2); RecordSet Track3 = new RecordSet("My life",3);...
4
by: dowlingo | last post by:
Hi, I am using Access 2000. I have a table full of records. Each record holds a value that I want to use in VBA code. Does anyone know how to take the value from the field, put it into an...
1
by: Newbie | last post by:
Hi All Wondered if you could help. I have created a little backup routine (using classic ASP and ADO) to get my data from my db into a bespoke XML file, ie I query the data into a recordset,...
7
by: ammmmmu | last post by:
Hi all, I am using VB 5.0 and msaccess as a database, I am reading the data from logfiles and inserting it in db, its not throwing any error, but after excecution I not find any records in table...
10
by: metalheadstorm | last post by:
OK i have two listboxes that are populated by data from a Access Db, its populated by a if statement sayin if the data is the same as todays date put it in list box1 and if its tomorrows date but...
2
by: rocketfire97 | last post by:
I'm trying to call a COM object using C# but having no luck getting values back for passed in ref objects. I've tried the same call using VB.NET and can get data back. How would I implement the...
1
by: cwfontan | last post by:
I am uploading a file renaming it with text from input here is the sql insert code and error im getting. If you need more of the code let me know.. This exact code is working when inserting into...
0
NeoPa
by: NeoPa | last post by:
Introduction: We get fairly frequent questions on here about why settings (including both values AND formatting) of unbound controls on a form, are not stored for reference later, but instead, each...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.