shanerobinson Posted August 13, 2008 Share Posted August 13, 2008 Hi Everyone,I have a simple database which contains a field named link which when i display this onto a page i need to remove a value from each record and replace it with the value contained within a cookie.The cookie is all set up and the recordset fetches the values etc im just stuck on setting a replace criteria up.. any help would be appreciatedThanks...(below are the parts of my code which may need modifying?)Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")Recordset1_cmd.ActiveConnection = MM_conn02_STRINGRecordset1_cmd.CommandText = "SELECT * FROM creatives" Recordset1_cmd.Prepared = true<%=(Recordset1.Fields.Item("link").Value)%> Link to comment Share on other sites More sharing options...
justsomeguy Posted August 13, 2008 Share Posted August 13, 2008 There's an example of using an update query with a prepared statement here:http://bytes.com/forum/thread589096.html Link to comment Share on other sites More sharing options...
shanerobinson Posted August 14, 2008 Author Share Posted August 14, 2008 Thankyou i found that very useful.... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.