p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Re: Strange datatyping


Message #1 by "Sandra" <salau@p...> on Thu, 6 Jun 2002 22:23:54
Hi Futuh!

This time it's my turn to apologize ;) Sorry, I missed that one, must 
have been sleeping when I replied to that post. But thanks for all your 
prompt suggestions and help! 

Sandra ^_^

Message #2 by "Futuh COKLU" <futuh@p...> on Tue, 4 Jun 2002 11:02:05 +0300
Hi Sandra,

I have been warned by Peter on 22/5 about my mistake and accepted that it
was my fault. Most probably you missed this message. Anyway I'm happy to
hear you solved the problem.

Best Regards
Futuh


Message #3 by "Sandra" <salau@p...> on Mon, 3 Jun 2002 19:02:34
Hi Futuh, 

No, you can't declare variables like that in Visual InterDev when working 
with ASP (VBScript). That's how you would declare them in VB - be careful 
of that. Doing that generates some pretty strange errors. 

------------------------
dim myVar as Integer  <--example of Futuh's suggestion
------------------------

The answer to my question, I found was that when you read in values from 
an Oracle instance, they change the data into strings. Thus I had the 
datatype error. This is NOT the same as Access... Access is nice enough to 
send numeric values in as number, not as string.

The suggestion someone made in the post above did work - all I had to do 
was convert from string to integer, which CInt conveniently does for me. 

Thanks for all your help everyone!
Sandra ^_^

  Return to Index