formatting error

[evr72]

Hello,

I am trying to format a null field so I came up with the code below, it looks ok to me but it is giving me an error

this is my code

strValue = "<a target=_blank href='[URL unfurl="true"]http://mywebsrv/sales_list.asp?mastertable=Daily&masterkey1="&[/URL] data("tddt") &" '>"("0" & data("Sales"),2) &" </a>"

this is the error I get

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "'>"]'

 

[ChrisHirst]

Use

" & chr(34) & "

instead instead of throwing the odd single quote here and there.


Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[guitarzan]

Guessing, but is this what you were going for?

strValue = "<a target=_blank href='[URL unfurl="true"]http://mywebsrv/sales_list.asp?mastertable=Daily&masterkey1="&[/URL] data("tddt") &" '>"[highlight #FCE94F] & Right[/highlight]("0" & data("Sales"),2) &" </a>"

 

[evr72]

ChrisHirst,

Thanks, would this be instead of the

"0" &

Thanks!!