[arobbo61]

hello

am a little stuck here

in my database one very important table has its key made up of text and numeric data.

When i'm passing that key from one asp to another page using the

lngRecordNo = CLng(Request.QueryString("ID")

bit its giving a type mismatch , i'm taking it thats because CLng converts to a long integer, is there anyway i can simply pass text and numeric from one page to another ???

would really appreciate any help here .. cheers

Andy

[chirag]

What is the datatype of

"lngRecordNo" in database

if its alphanumeric you need not apply the clng function at all..

[arobbo61]

yes in access talk it is type text

so if i did

lngRecordNo = Request.QueryString("ID")

would that work or need any other prefix's

?

thanks for your prompt reply ... its people like you that make programming possible for beginners like me

[Naresh Rohra]

if u simply need to pass value from one page to another page u can use following statment.

Like:

<A HREF="www.Programmingtalk.com?lngRecord= <%= Request.Querystring %> "> Click </A>

This will pass the value through querystring in address bar.

Cheers.
Naresh.

[arobbo61]

how would i then retrieve it at the other end
?
and pass it to lngRecordNo

[chirag]

Hi,


you must write like:

1st page
http://abc.com?id=yourvalue

2nd page
lngRecordNo = request.querystring("id")

[arobbo61]

THanks i tried that and still got the error message Too few parameters expected 1 .........

its not to do with your code that seems to pass the data fine just have no idea where its falling down ???
hmmm i'm fresh out of ideas with this one

thanks for your helpthough is really appreciated

[chirag]

Can u post your code for both the files.....?