I have the following:
dim app_ids, irowloop, icolloop
app_ids = get_app_logins(session("stremail"))
for irowloop = 0 to ubound(app_ids, 2)
for icolloop = 0 to ubound(app_ids, 1)
response.write(app_ids(icolloop, irowloop) & ",")
next 'icolloop
response.write("|")
next 'irowloop
That returns:
0,0,bobsmith,pAssWord,|0,71,tom,tom,|0,71,tomf,pAs sWord,|1,5,tom,a1,|
Is it possible to remove the final ',' before the '|' ??
Thanks! 2 1412
j1c wrote: I have the following:
dim app_ids, irowloop, icolloop app_ids = get_app_logins(session("stremail")) for irowloop = 0 to ubound(app_ids, 2) for icolloop = 0 to ubound(app_ids, 1) response.write(app_ids(icolloop, irowloop) & ",") next 'icolloop response.write("|") next 'irowloop
That returns: 0,0,bobsmith,pAssWord,|0,71,tom,tom,|0,71,tomf,pAs sWord,|1,5,tom,a1,| Is it possible to remove the final ',' before the '|' ??
Well, you could avoid writing it in the first place.
for irowloop = 0 to ubound(app_ids, 2)
for icolloop = 0 to ubound(app_ids, 1)
if icolloop = 0 then
response.write app_ids(icolloop, irowloop)
else
response.write ";" & app_ids(icolloop, irowloop)
end if
next 'icolloop
response.write("|")
next 'irowloop
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Croney69 |
last post by:
I am getting information out of a table to place into to
an Array.
rs=DataConn.Execute(strSQL)
At this point I place it into the array
objArray=rs.GetRows()
But how do I handle things if...
|
by: Moshe |
last post by:
I'm facing an odd behavior in using the GetRows Method. I'm not sure what's
causing it because it has been working fine until now.
I have a sproc that returns 1 row. I display the RS info on the...
|
by: Harag |
last post by:
Hi All
I currently thinking of converting from my little knowledge of
VBscript to jScript ASP.
With this in mind I'm looking at my current code to see how it will
convert over to Jscript.
...
|
by: Laphan |
last post by:
Hi All
I'm using .getRows() with a local var array instead of doing a recursive
loop so that I'm being a good ASP newvbie and closing my object i/o's (the
recordset in this case) as quick as...
|
by: bajopalabra |
last post by:
hi
session("myVar") = rs.getRows( )
don't work when number of records
is greater than 10
does anybody know WHY ???
is it a Session object limitation ???
thanks
|
by: Hank |
last post by:
Hello,
I'm having trouble reading from a table directly into an
array using Access 2000.
Dim db As Database
Dim rsTime As Recordset
Dim TimeArray As Variant
Set db = CurrentDb
Set rsTime =...
|
by: colm1974 |
last post by:
Hi,
I hope somebody can help. I have been trying to use the GetRows method but it only seems to work when there are no constants assigned.
aGetElement = rs_zgl_element.GetRows()
This works and...
|
by: FrozenDude |
last post by:
Help! I'm a VBA newbie and am having trouble getting the array values
retrieved from getRows into a series of individual variables.
Here is the query: "Select parcelID, DueDate from tablename"
...
|
by: ADezii |
last post by:
One question which pops up frequently here at TheScripts is: 'How do I retrieve data from a Recordset once I've created it?' One very efficient, and not that often used approach, is the GetRows()...
|
by: ADezii |
last post by:
Last Tip, we demonstrated the technique for retrieving data from a DAO Recordset, and placing it into a 2-dimensional Array using the GetRows() Method. This week, we will cover the same exact Method...
|
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: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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: 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: 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,...
|
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,...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |