Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 26th, 2004, 01:31 AM
Registered User
 
Join Date: Mar 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default assign a recordset to a variable

Bit of a newbee question

I need to add 3 repeating fields from a orders table into one variable. I can display the records but not sure how to store them in a variable.

For example my variable is "items"

recordset fldName fldNum fldQty

variable "items" should = tshirt 123abc 5, shorts 123xyz 2

and so on

any ideas!

 
Old March 26th, 2004, 02:26 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 627
Thanks: 0
Thanked 0 Times in 0 Posts
Default

dim myItem as String
string = rc.fields(0).value + " " + rc.fields(1).value + " " + rc.fields(2).value

is it this you asked for?
Marco





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to assign a new value to Classic ASP variable mcinar Javascript How-To 4 April 14th, 2008 06:02 PM
Assign Session variable from view or controller Alaphat ASP.NET 2.0 Professional 2 April 11th, 2008 09:37 AM
assign XSLT variable to a wml variable arunagottimukkala XSLT 2 October 19th, 2007 05:15 AM
assign javascript variable to asp variable manjunath_c_k Classic ASP Basics 1 September 14th, 2006 07:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.