1. SELECT VALUES FROM TABLE A WHERE ID=5
2. I create an array x(0,n), and I populate n with the values based on
select above.
What I have... I have x(0,1)
x(0,2)
x(0,3)... and so on.
Result:> I need to have variable called
varx that should consist all the values from x(0,1), x(0,2), x(0,n).
So I need to declare varx = x(0,1) & "," & x(0,2) & etc.
1. question. I don't know how many elements I would have, coz they depends
on "select".
2. Can someone give me example how I can dynamicly create (parse) this
values in single variable, so I can send this values to pageB.asp 3 1586
Need_help wrote: 1. SELECT VALUES FROM TABLE A WHERE ID=5
2. I create an array x(0,n), and I populate n with the values based on select above.
What I have... I have x(0,1) x(0,2) x(0,3)... and so on.
Result:> I need to have variable called varx that should consist all the values from x(0,1), x(0,2), x(0,n).
So I need to declare varx = x(0,1) & "," & x(0,2) & etc.
1. question. I don't know how many elements I would have, coz they depends on "select". 2. Can someone give me example how I can dynamicly create (parse) this values in single variable, so I can send this values to pageB.asp
This demonstrates using GetRows to create your array and also shows how to
process the resulting array. For more detail, see ADO online help at
msdn.microsoft.com.
dim cn,sConnect,sSQL,rs,ar, iRow, iCol
sSQL = "SELECT VALUES FROM TABLE A WHERE ID=5"
'for debugging purposes:
response.write sSQL
'you can get rid of this line when debugging is complete
sConnect = "<valid connection string>"
' - see www.able-consulting.com/ado_conn.htm - concentrate on the
'OLEDB connection examples for your database
set cn=server.createobject("adodb.connection")
cn.open sConnect
set rs=cn.execute(sSQL,,1)
if not rs.eof then ar=rs.getrows
rs.close
set rs=nothing
cn.close
set cn=nothing
if isarray(ar) then
for iRow=0 to ubound(ar,2)
for iCol = 0 to ubound(ar,1)
response.write ar(iCol,iRow) & "; "
next
response.write "<br>"
next
else
response.write "no records were returned"
end if
HTH,
Bob Barrows
"Need_help" wrote: 1. SELECT VALUES FROM TABLE A WHERE ID=5
[snip] http://www.aspfaq.com/5005
--
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.
Try the "join" function
Description
Returns a string created by joining a number of substrings contained in an
array.
Syntax
Join(list[, delimiter])
The Join function syntax has these parts:
"Need_help" <no****@nospam.hr> wrote in message
news:uw**************@tk2msftngp13.phx.gbl... 1. SELECT VALUES FROM TABLE A WHERE ID=5
2. I create an array x(0,n), and I populate n with the values based on select above.
What I have... I have x(0,1) x(0,2) x(0,3)... and so on.
Result:> I need to have variable called varx that should consist all the values from x(0,1), x(0,2), x(0,n).
So I need to declare varx = x(0,1) & "," & x(0,2) & etc.
1. question. I don't know how many elements I would have, coz they depends on "select". 2. Can someone give me example how I can dynamicly create (parse) this values in single variable, so I can send this values to pageB.asp
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Wayne Wengert |
last post by:
I have a solution. I want to clone it to try some different options. Is
there a way to open Solution A, save it as Solution B and then be able to
try some things in Solution B without affecting...
|
by: Simon Jefferies |
last post by:
Hello,
I'm getting a strange problem where when I load up my solution that has
three projects:-
a managed C++ .NET, one C++ lib, and a VB library.
It locks up and doesn't load completely, I...
|
by: TEK |
last post by:
Hello
We have a quite huge project.
To limit the solution size, rebuild time and so on we have divided the
project in two different solution.
One solution that holds the buiness entities, or...
|
by: I_AM_DON_AND_YOU? |
last post by:
I have a small VB.Net Solution. The solution has filename LABELMAKER.SLN and
the the project has filename LABELMAKER.VBPROJ. There is another file
LABELMAKER.VBPROJ.USER. All these are in a...
|
by: kai |
last post by:
Hi,
I use XP Pro and VS2005. I find when I create a new Website, I only see the
Project node not Solution. After I add sedcond project under the solution
tree, then I see the solution node.
How...
|
by: mkd1919 |
last post by:
I'm developing a web service that will eventually be sent to other like
organizations to communicate for a particular application. After a few
weeks, I decided it would be better to split of the...
|
by: Manikandan |
last post by:
Hi,
I'm copying projects from a solution in the vss.
In my local system i created solution ,added that project(make
modification related to solution)
When i added this solution to vss, projects...
|
by: techie |
last post by:
List of Solution manuals:
Engineering Circuit Analysis 6Ed - Hayt Solutions Manual
Norbury - Solutions manual for mechanics and thermodynamics
Physics For Scientists And Engineers - Solution...
|
by: GaryDean |
last post by:
I know this is a vs issue but nobody seems to answer posts over there...
In VS 2008 I can't seem to get a multiple project solution. If I create a
blank solution and add a project to it, it...
|
by: =?Utf-8?B?RHdlZWJlcmVsbGE=?= |
last post by:
I created an Access 2007 application for my customer. The application is
shared by three employees on a server. It maintains a contact list including
financial data and social security numbers. ...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
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$) {
}
...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|
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,...
| |