Use "&" for string concatenation, instead of "+".
i.e.
Response.Write "<a href=""#""
onMouseDown=""javascript:NewWindow('product_detail.asp?prodid=" &
productsResults.Fields.Item("PRODID").Value &
"','productDetail','450','370','no')"">Full Spec</a>"
I suspect productsResults.Fields.Item("THUMBNAIL").Value works with "+"
because it's a string and productsResults.Fields.Item("PRODID").Value is
a number?
pg
-----Original Message-----
From: jake williamson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 September 2002 3:08 AM
To: ActiveServerPages
Subject: Re: desperate! null detect just not working!!
hi jesse and tore,
thanks for getting back to me - been on the case with this one for dome
days (damn slow posts on the list!) and this is code developed:
<%
If IsNull(productsResults.Fields.Item("THUMBNAIL").Value) or
productsResults.Fields.Item("THUMBNAIL").Value = "" then
Response.Write ""
Else
Response.Write "<img src=""prod_tn/" +
productsResults.Fields.Item("THUMBNAIL").Value + """>"
End If
%>
which is wicked! got a small problem though....
i've been trying to use the same piece of code again for a 'larger view'
link that works on the product id which is a number. the code looks
like:
<%
If IsNull(productsResults.Fields.Item("THUMBNAIL").Value) or
productsResults.Fields.Item("THUMBNAIL").Value = "" then
Response.Write ""
Else
Response.Write "<a href=""#""
onMouseDown=""javascript:NewWindow('product_detail.asp?prodid=" +
productsResults.Fields.Item("PRODID").Value +
"','productDetail','450','370','no')"">Full Spec</a>"
End If
%>
the weird thing is it throws up this error:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "<a href="#" onMouseD"]'
if i change the requested field to any other result on in the query (eg
the THUMBNAIL) it works fine! but obviously dont send the info onto the
detail page.....
in addition, just tried it with the price of the item (which is also a
number) and it came up with the same error! must have something to do
with the difference between text and numbers??
it's almost as if i need to change the style of return, i.e. it's a
number. the weird thing is, i i use it as a regular link it works fine?
any ideas??
many, many thanks for your help,
jake
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To
unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
