Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP DB manager??

Status
Not open for further replies.

JHerr

Programmer
May 25, 2001
42
US
Ok, does anyone know of an asp database management tool like the one at Brinkster.com? i mean you can enter a sql statement in the text area, and have it return an rs, or just execute a statement. its really great, and i want one for me to use on my site, i just can't seem to find one.
i know someone must know of one, so help!!!! i'm sure i can't be the only one looking.
 
just write a statement to execute your your sql (retrieve it a form and put it into a variable)
when it is a select sql put the values into an array and then use this script to output the contents of that array
(change arrAllCashup to the name of the array you use)

Response.Write &quot;<table>&quot;
for i = 0 to uBound(arrAllCashup,2)
Response.Write &quot;<tr>&quot;
for j = 0 to uBound(arrAllCashup)
Response.Write &quot;<td>&quot; & arrAllCashup(j,i) & &quot;</td>&quot;
if j = uBound(arrAllCashup) then
Response.Write &quot;</tr>&quot;
end if
next
next
Response.Write &quot;</table>&quot;

good luck!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top