apologies - here are the relevant asp lines for retrieving a salary from the database
'Get job data
rs.Open "select * from vacancy where status = 'active' order by id desc", dbConn, 1
Response.Write("<h4>Salary: " & rs("salary") & "</h4>")
and this is the code for inserting into the database, where salaryInput is a variable storing the value submitted in a form field
sqltext = "insert into vacancy (title,....,creator) values ("
sqltext = sqltext & "'" & replace(salaryInput, "'", "''") & "', "
'the rest of the inserts
sqltext = sqltext & "'" & replace(Session("creator_id"), "'", "''") & "') "
the problem with displaying the £ sign is in Safari, which displays a � instead.
the problem with the apostrophe is when i am retrieving data from the database to use as the title tag for an image - if there is an apostrophe in the image description, then the title tag cuts off the rest of the text after the apostrophe
i thought that both of these problems may be a result of the same issue, in terms of how i'm handling the data? hope this make more sense