«

hi how would you go changing a random number generated into a item
drawn from a database with SQL

isaac2004 wrote on 11 feb 2006 in microsoft.public.inetserver.asp.general:

> hi how would you go changing a random number generated into a item
> drawn from a database with SQL

You mean having a variable filled with a random number,
and then filling that variable with the value of a database field?

It wouldn't be random then?


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

no having a random item be generated to a page. the items are on the
database and using SQL to generate a random item name using the
Randomize function

isaac2004 wrote on 12 feb 2006 in microsoft.public.inetserver.asp.general:

> no having a random item be generated to a page. the items are on the
> database and using SQL to generate a random item name using the
> Randomize function
>

Please quote what you are replying to.

If you want to post a followup via groups.google.com, don't use the
"Reply" link at the bottom of the article. Click on "show options" at the
top of the article, then click on the "Reply" at the bottom of the article
headers. <http://www.safalra.com/special/googlegroupsreply/>

==============================

I still do not understand what you are asking, Isaak

What is a "generated random item"?
And you have no[t] genreated it to(?) a page?

Tell us about the type and content of your databse, and show us the
relevand ASP code, you have come up with so far.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

my database consists of two tables one vendors and other Items, i want
to have a page on my site that when viewed a random item is displayed
such as


Today we have a sale on Tight Fit Denim jeans by Polo
----------------------------------->
this is the random item
the item is randomly generated by a randomizer that picks the item name
out of the database and displays the item name, item type, and price

i use this code

randomize
intItemID = Int(22* rnd(1)) +1
for the random but i dont know how to convert the random number into
the item type. this is for my asp class, if you want a working example,
go here

http://yorktown.cbe.wwu.edu/sandvig/...RandomItem.asp

thanks for the help

isaac2004 wrote on 12 feb 2006 in microsoft.public.inetserver.asp.general:

> my database consists of two tables

If you persist neglecting usenet netiquette by not quoting,
even when politely asked,
I will stop anwering you on your topic.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

>If you persist neglecting usenet netiquette by not quoting,
even when politely asked,
I will stop anwering you on your topic.

sorry i forgot

>I still do not understand what you are asking, Isaak


>What is a "generated random item"?
And you have no[t] genreated it to(?) a page?


>Tell us about the type and content of your databse, and show us the
relevand ASP code, you have come up with so far.

my database consists of two tables one vendors and other Items, i want
to have a page on my site that when viewed a random item is displayed
such as

Today we have a sale on Tight Fit Denim jeans by Polo
----------------------------------->
this is the random item
the item is randomly generated by a randomizer that picks the item name

out of the database and displays the item name, item type, and price


i use this code


randomize
intItemID = Int(22* rnd(1)) +1
for the random but i dont know how to convert the random number into
the item type. this is for my asp class, if you want a working example,

go here


http://yorktown.cbe.wwu.edu/sandvig/...SQL/RandomItem...



thanks for the help

isaac2004 wrote on 12 feb 2006 in microsoft.public.inetserver.asp.general:

> randomize
> intItemID = Int(22* rnd(1)) +1
> for the random but i dont know how to convert the random number into
> the item type. this is for my asp class, if you want a working example,
>

SQL = "SELECT * from tblX WHERE ID = " & intItemID

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

>SQL = "SELECT * from tblX WHERE ID = " & intItemID

doesnt this code just source from the databse but not put it through a
random number generator

isaac2004 wrote on 12 feb 2006 in microsoft.public.inetserver.asp.general:

>>SQL = "SELECT * from tblX WHERE ID = " & intItemID
>
> doesnt this code just source from the databse but not put it through a
> random number generator
>

No, you came up with the random number generator, remember:

>> randomize
>> intItemID = Int(22* rnd(1)) +1

so intItemID was defined.

Please do not use inconclusive terminology like "just source from"

Better show us the code you have so far.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)