Difference Between Getrows
What is the difference, and when to use one over the other?
View Replies
ADVERTISEMENT
GetRows + GetRows?
I'm using getRows in two different SELECT stataments and want to know if it's possible to place the data in the two getRows into one array? Lets's say I have something like this:
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "Select test FROM Table WHERE id = "&id&""
rs.Open strSQL, Conn
contentFirst = rs.GetRows
Set rs2 = Server.CreateObject("ADODB.Recordset")
strSQL2 = "Select id FROM Table WHERE id = "&id2&""
rs2.Open strSQL2, Conn
contentSecond = rs2.GetRows
Now what I want is a variable that holds the content of contentFirst and contentSecond like this: content = contentFirst + contentSecond
Can this be done in some way with arrayas? How?
Can GetRows() Do...
I was reading a sample on ASP101 (i love them), and it was, I think, saying u could specify the record u want to start at...is that true? If so, I think EVERYONE should use it...it would be very cool.
Because, if u need the 6th record, u can just get it, but, using a recordset, it would be, i believe, impossible...right?, or is that wat bookmarks are for?
GetRows
I tried to get the data in array by using getrows. Data will be display in the drop down list in the future. i call a function to get the data. It should be return 8 rows of the data. But it return 0 row of data ....
View Replies View RelatedGetrows()
I'm using getrows to return the values from two columns in a MSSQL sql
database. Looping through them like so:
dim irowloop, icolloop, i
for irowloop = 0 to ubound(instances, 2)
for icolloop = 0 to ubound(instances, 1)
response.write("<option value=""VAL"">") 'get 2nd col val
response.write(i(icolloop, irowloop))
response.write("</option>")
next
next
How can I get the value of the second column into the VALUE=""attribute in the drop down?
Using GetRows()
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 the rs came back blank? What happens is that the loop encounters an error?
Rs.GetRows Issue
Since I never user .GetRow, (because arrays drive me crazy) I thought I'd give it a shot with something I had to do, unfortunately I get several errors. Code:
View Replies View RelatedPages And GetRows
I built a recursive forum (tree) with ASP (VBS) and getRows and the DB Microsoft Access.
When I tried to add a pages division (with ADO) it destroyed everything
The relevant code:
The ADO pages devision:
rs.PageSize = MessagesNum
rs.CacheSize = MessagesNum
If Not rs.EOF Then
PagesCount = rs.PageCount
rs.AbsolutePage = Page
arr = rs.getRows
End If
Code:
GetRows() & Arrays
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 '|' ??
ASP Getrows And SHAPES
I recently learned about the wonders of the getrows statement on a recordset (IE alldata=rstemp.getrows). It dumps a recordset into an array, that I get. Sounds great! My question is: Is there a way to support a SQL shape statement using the getrows statement? I'm guessing that if I try to throw that into a variable it may not like it.
View Replies View RelatedGetstring / Getrows
I know that getstring or getrows increase performance but my question when to use this method. This is because what I know is this method will output all fields in a table and not just certain few.
View Replies View RelatedGetRows() And Hyperlinks
<%
' Loop through the array holding the result set and display the data
For iCounter= varC1Begin to varC1End
Response.Write("<a href=prices.asp?manuf=" & arrResultSet(0,iCounter) & ">"
& arrResultSet(0,iCounter) & "</a><br>")
Next
%>
In the above Response.Write statement arrResultSet(0,iCounter) displays the
manufacturer just like it should.
However, within the hyperlink, if a manufacturer has 2,3, or more words, it
will only show the first word. Anything after the first space is ignored.
Why?
GetRows Method
When querying a database, I know I can fix the no. of returned rows/results to 20 (for example) using the GetString method:
myVar = objRs.GetString(, 20, , ,)
What syntax do I need to use to do the same with the GetRows method:
myVar = objRs.GetRows ?
JScript & GetRows
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.
One thing I have spotted that I can't think of a way round is the ADO
recordset.GetRows command.
I have a VBscript class that handles my DB connections so in short I
can do things like
MyArray = clsDB.GetRecordsInArray("Stored Proc Name/SQL", other
params)
and this would return the rows into a 2 dimension array.
Problem is I've read that Jscript only has one dimension. So how is
the "getRows" solved for Jscript.
Also is there any good "Jscript" code learning sites?
Getrows Get More Than Rs Length!!
I am reading an recordset into an array using getrows, but my recordset has 38 records but my array has 46!!
If I loop through the array, it errors on number 38 (as expected). I am using UBound to find the array length.
can anyone think what is going wrong, without the need to post my code (step 2!)?
Join And GetRows
I'm using the following JOIN query;
Code:
strQuery = "SELECT whoisserver.host, [domain].domainid, [domain].[domain]" & _
" FROM [domain] INNER JOIN [whoisserver] ON [domain].whoisserverid = whoisserver.whoisserverid"
Which works perfectly. when I use getRows to store the results in an array, the whoisserver.host field isn't in the array. Only the domain.* fields are in the array. Anyone know why this is, and how to solve it? I really need that whoisserver field.
Getrows, Paging And Limiting
I'm using getrows to speed up data access time, i wonder though if there is a better way. Each recordset returns up to or more than 500 records, this is still quite an overhead for the server when there are lots of people on the site.
Rather than reading all 500 records into the array and then paging the results is it possible to create the recordset with just 25 entries?
ie if you are on page 1 then only the first 25 records are retrieved from the database, page 2 - records 25 - 49 are retrieved etc
or will this slow things down?
Getrows For Categories Then Products
im developing a Product configurator (just like alienware use) where in my database i have
(systems table) a list of PC systems
systemID
(categories table) a list of PC product categories (ie. CPU, RAM...)
categoryID
(products table) a list of all products
productID, catID
(link table)
sysID and prodID
Now before i put the code ive done so far, let me explain that the first page lists all systems wich then gives the systemID for the link table. Once this page loads it needs to go through each category then list the products available to that category where sysID = systemID. Now a query i put together to list all products for that sysID is:
select * from PRODUCTS inner join link on link.prodID = PRODUCTS.productID where link.sysID=systemID
Now this query works great and lists all of the products for that systemID, but what im unable to do is (using GetRows()) have the category name listed as a title then have each product under the respected category. Code:
MyArray = Recordset.getrows
would this code give an EOF or BOF error if there are no rows in the
recordset? or the array myArray would be just null?
Getrows And Dicitonary Objects
I can't seem to get the getrows function of an ADO recordset to work or get a dictionary object to work. I've made them work on other servers before using the same code.
Server is running Windows Powered and IIS 5.0I can provide code, but you must believe this code has worked on other servers.
Class To Ease Use Of GetRows()
I was bored this weekend and after reading a couple articles and posts about GetRows() being WAY better than the usual way, I thought I would try and make a class to make it similar to using a recordset.
It's far from finished but I thought I would throw it up here and see what everyone thought. Am I wasting my time? I have no real way of benchmarking the possible improvements but I haven't been able to notice a difference yet. Anyway, you can download it here. The zip includes the class file and an example asp file.
GetRows With Field Names
When using RS.getRows how do I go about getting the field names from the database as well?
View Replies View RelatedGetRows And Insert/Select Statements
I'm using an SQL statement like the following:
Code:
INSERT INTO table (field) VALUES (value) SELECT @@IDENTITY AS NewIdent;
If I run it through a command prompt (osql.exe) it works fine - it inserts the data and returns the new identity. However, when I try to pass this through my nifty GetRows() function the stupid thing chokes (it acts like a normal INSERT statement has been passed - "ADODB.Recordset (0x800A0E78) Operation is not allowed when the object is closed." on the line where I try to execute GetRows).
I've looked through my ADO documentation and don't see any reason why this should be happening (since it does return data). Due to the small amount of data, I'm going to just use a plain old RecordSet object, but for my own piece of mind does anyone know why it won't treat the returned @@IDENTITY variable like normal data?
Getrows(), Load Column Into Variables
if there is anyone knows if its possible to put a database columns' value such as ( Title, Name, IP, Phone, Address, etc... ) into array then retrieve them to be displayed on page via Access in ASP using getrows but utilize something similar to rs("Title"), rs("Name"), rs("IP"), etc., or create temperay new variables such as rs(vTitle), rs(vName), rs(vIP), instead of using the rs( row, column ).
The reason I am asking is that when a table has many fields, its gets hard to track down the right array number instead of simply using its column or field name.I have written paging scripts based on ADO method of getting rs("FIELDNAME") to display datas, and I am trying to convert it to utilize getrows() method, but having trouble with the array column sequence.
IsArray Doesn't Work With Array Var Populated With Xxx.GetRows()
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 possible.
My problem is that I can't seem to use this to complete good effect because
the IsArray statement doesn't seem to work with a local var array that has
or has not been populated with the .getRows() property.
To explain, I used to do the following recursive loop (simplified to show a
concise example): Code:
Difference B/T ASP And ASP.NET
I have been looking around at various design solutions for uploading a file using ASP and have found that many sources have devised a much simpler plan using ASP.NET.
My question is this, I have a box running Win2k Advanced Server, with the .NET framework installed. WIll that enable me to run some of the new functions etc. decribed in ASP.net ??
What's The Difference Between ASP And .Net?
What's the difference between ASP and ASP.Net? Which one should I learn in order to start making dynamic web pages for the internet?
View Replies View RelatedDifference Between MAX And MIN
So I need to write the difference between the biggest and the smallest number in database table. I know that I need to take MAX and MIN from table, but I just can't get it work.
Example:
Let's say max = 5 and min = 1, I need to have it like this:
5-1=4 (max-min=total)
What Is The Difference Between <% And <%#?
Maybe my books are just sorry, but I can't find a description of what <%# is supposed to mean. I find Dreamweaver inserting it often.
View Replies View RelatedDifference Between ASP And ASP.net
Is there any technique available that my asp code will convert into asp.net
View Replies View RelatedDifference
What is the difference between
Code:
<meta http-equiv="refresh" content="5;url=menu.asp">
and
Code:
Responce.Redirect("")
Which one would you chose?
Time Difference
is there anybody know to code the time difference in asp? i used timediff, it returned a date, it should return a time actually. i tried the command in mysql n it's fine. but it's error when i switched to ASP. i hv refered to alot references such as sql time manual n other sites. but stil fail to find ans.
View Replies View RelatedMain Difference
i have a problem with differentiating these
response.redirect()
server.transfer()
server.execute()
do they all perform same?