url variables 1

[pourlefun]

I created a page : index.asp, but when I open it this error is displayed: Microsoft OLE DB Provider for ODBC Drivers error '80040e07' Syntax error converting the varchar value 'undefined' to a column of data type int.
But when I open index.asp?page=1 or page=2... everything works so well and all the information is displayed correctly.
do you have any clue!!
thanks

 

[onpnt]

well the fact that the when you hard code the value it works says the value is not being passed dynamically and thus throws a database error on the null (undefined) value being added to a SQL statement

We need details!!!!

Some code. what is going on. are you submitting a value via GET? what is the database portion doing.



___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811

 

[pourlefun]

Well, I agree that I have to start the page at 1 in order to display dynamically other pages from the Date Base.
my code is this:
<%
curr=parseInt(Request.queryString("page"))
con=Server.createObject("ADODB.Connection")
con.open("transact", "sa", "gouba570")
rs=con.execute("SELECT nom, num_cat FROM categories ORDER BY(num_cat)")
ds=con.execute("SELECT description, nom FROM categories WHERE num_cat='"+Request.queryString("page")+"'")
......
'crating categories
<%
while(!rs.EOF){

if(rs.fields(1).value!=curr){%>
<td class="sous" width="10%"><%} else{%>
<td class="men" width="10%"><%}

Response.write('<a href="index.asp?page='+rs.fields(1).value+'" class="lier">')

Response.write(rs.fields(0).value)

Response.write('</a></td>')
rs.moveNext()

}%>

.......
'creating categories description
<tr><td align="center" class="des"><% Response.write(ds.fields(0).value)%></td></tr></td></TR>

I hope you understand my problem
thanks in advance

 

[onpnt]

the first statement should output this

SELECT nom,num_cat FROM categories  ORDER BY num_cat

as is your telling the database you want a function called BY(). just get rid of the () and adda space

are declaring the use of jscript?

next. you parseInt the querystring but tehn surround it in quotes making it a string. which is it in the DB? varchar or int

you may just need to get rid of teh quotes

ds=con.execute("SELECT description, nom FROM categories WHERE num_cat=" + Request.queryString("page"))

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811

 

[pourlefun]

yes I am declaring the use of Jscript

 

[pourlefun]

here is what it says:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'NaN'.

/swt/index.asp, line 14

 

[onpnt]

NaN = Null

You're not passing the QueryString. Thats why it works when you hard code the path.

whats going on in the page that contains teh form that is submitted to this script

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811

 

[pourlefun]

which form? I have no forms in the page.
I am desperate...

 

[pourlefun]

I created a page called home.asp and it redirect to index.asp?page=1, then when I click on different categories, everything is working.
The thing is why index.asp show always the same error!!!

 

[pourlefun]

no clue yet!!

 

[ChrisHirst]

I don't see anything in your code that gives "page" a default value should it be passed as blank. So if you call the index page without a querystring it will throw an error.




Chris.

Indifference will be the downfall of mankind, but who cares?

 

[pourlefun]

Thanks, but I can't figure out how to fix that. I gave "page" 1 as a value, but the porblem remains the same.

 

[ChrisHirst]

you could use

if Request.queryString("page") = "" then
   curr = 1
else
   curr = parseint(Request.queryString("page"))
end if

or any other method of checking you prefer

you also are using the querystring here

..WHERE num_cat='"+Request.queryString("page")+"'")

instead of your variable.


Chris.

Indifference will be the downfall of mankind, but who cares?

 

[pourlefun]

here is the code I wrote:
if(Request.queryString("page") =="" ){
curr = 1}
else{
curr = parseInt(Request.queryString("page"))
}

but the error is the same
my head is getting biggggggger and heavier

 

[pourlefun]

CAN anyone help!!!!!
pleasssssssssse

 

[ChrisHirst]

have you rewritten this bit ?

..WHERE num_cat='"+Request.queryString("page")+"'")

to

..WHERE num_cat='"+curr+"'")

Chris.

Indifference will be the downfall of mankind, but who cares?

 

[pourlefun]

Yes I did.
And the error is :
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value 'undefined' to a column of data type int.

thank you

 

[pourlefun]

I think that the problem is not with "page" but with the index.asp itself! Am I right?

 

[ChrisHirst]

the problem is you are comparing an string to a integer field


remove the single quotes. (as stated in onpnt's post)

..WHERE num_cat= "+curr)

Chris.

Indifference will be the downfall of mankind, but who cares?

 

[pourlefun]

I did remove them, but the error is exactly the same.