C
Coz
Hi all,
I'm new to ASP so this is probably a problem caused by me.... but here goes.
I have been pulling some information from an access database (specifically a
postcode)
eg. GL3 2SD, I need to swap the space " " for an plus sign "+" and have been
trying to use this code -
<%Dim ModPostCode
If GetPropertiesRecordset.Fields.Item("AddressPostCode").Value <> ""
Then
ModPostCode=GetPropertiesRecordset.Fields.Item("AddressPostCode").Value
Replace(ModPostCode, " " , "+")
=ModPostCode%>
Some other html........
<%End If%>
But I get this Error -
Microsoft VBScript compilation (0x800A0414)
Cannot use parentheses when calling a Sub
/searchresults.asp, line 354, column 31
Replace(ModPostCode, " " , "+")
I have tested all the lines to make sure that the data is OK and in the
variable 'ModPostCode', I just can't get the Replace command working... Any
ideas... anyone... please....
Cheers
Coz.
I'm new to ASP so this is probably a problem caused by me.... but here goes.
I have been pulling some information from an access database (specifically a
postcode)
eg. GL3 2SD, I need to swap the space " " for an plus sign "+" and have been
trying to use this code -
<%Dim ModPostCode
If GetPropertiesRecordset.Fields.Item("AddressPostCode").Value <> ""
Then
ModPostCode=GetPropertiesRecordset.Fields.Item("AddressPostCode").Value
Replace(ModPostCode, " " , "+")
=ModPostCode%>
Some other html........
<%End If%>
But I get this Error -
Microsoft VBScript compilation (0x800A0414)
Cannot use parentheses when calling a Sub
/searchresults.asp, line 354, column 31
Replace(ModPostCode, " " , "+")
I have tested all the lines to make sure that the data is OK and in the
variable 'ModPostCode', I just can't get the Replace command working... Any
ideas... anyone... please....
Cheers
Coz.