Hyperlink issue *twitch*

[Shisou]

So I think I might be going insane... I have two asp pages that are exactly the same code, I mean copy/paste exact. So naturally I would expect to get the same results out of it....

what a silly person i am... First the evil evil line of code....

Response.Write "<td><a href='http://" & Recordset1("URL") & "'>" & Recordset1("URL") & "</a></td>"
 

Both pages are running on my IIS and all the settings are the same. the only difference between the two setups is the database. The test environment is using SQL 2005 express and the production is using SQL 2000, but why should that make a difference?

here is the output from the test environment when you veiw source through IE7

<td><a href='http://www.test3.com'></a></td>
 

and from the production (which works properly)

<td><a href='http://mail.google.com'>mail.google.com</a></td>
 

I've tried posting this on the SQL forum and got no responses, so now i'm looking for another way to code it that might work better... any help would really be appreciated.

[jhardman]

Wow, that really is a sticker, no wonder no one else answered. try passing the value of recordset1("URL") to a local variable, say myURL or some such and using that. I don't know why it is failing, I don't see anything wrong, but that should clarify whether the db connection is failing.

Jared

[Shisou]

OMG! thank you so much! that fixed it... not sure what was causing it but putting it into a variable seems to fix it!

Thanks again!

[jhardman]

OMG! thank you so much! that fixed it... not sure what was causing it but putting it into a variable seems to fix it!

Thanks again!

glad it worked. I also have no idea why...

Jared