This will allow you to replace a letter or whatever with something else. Use it in reverse when pulling stuff out of a database. job_description = replace(job_description,"'","^") SHARETHIS.addEntry({ title: "Replace tag using asp", url: "http://code.netexceed.com/asp/replace-tag-using-asp/"...

How to read a table in SQL using ASP. Set objGetForm = cnnConn.Execute("SELECT * FROM crs_applicants") SHARETHIS.addEntry({ title: "Select statement with sql using asp", url: "http://code.netexceed.com/asp/select-statement-with-sql-using-asp/" });

This shows you how you can connect to a sql database using asp. It’s better to put this code in a seperate file and use a include statement. Set cnnConn = Server.CreateObject("ADODB.Connection") FilePath="DRIVER={SQL Server};SERVER=*****;UID=*****;PWD=*****;DATABASE=database_name" cnnConn.open...

This is how you update a row in SQL using ASP. strq = "UPDATE crs_applicants SET education_completed = " & education_completed & ", graduate = " & graduate & "" strq = strq & " WHERE tdb_id=" & tdb_id & ";" cnnConn.Execute strq SHARETHIS.addEntry({...

This is how you create a stored procedure in SQL. CREATE PROCEDURE update_new_insurance @first_name varchar(50), @last_name varchar(50), @ins_assign Integer, @db_id Integer AS UPDATE insurance_db SET first_name = @first_name, last_name = @last_name, ins_assign...

This shows you how to delete a row in sql using asp. strq = "DELETE FROM general_census WHERE db_id = " & db_id & ";" cnnSimple.Execute strq SHARETHIS.addEntry({ title: "Delete command in sql using asp", url: "http://code.netexceed.com/asp/delete-command-in-sql-using-asp/"...

Here is how to order by ASC or DESC in sql. Use ASC for ascending and DESC for Descending. Set objGetSort1ENTCensus = cnnConn.Execute("SELECT * FROM qxSQLCensusBasicView ORDER BY occupancy DESC") SHARETHIS.addEntry({ title: "ORDER command in SQL using ASP", url: "http://code.netexceed.com/asp/order-command-in-sql-using-asp/"...

Using the len variable we can check the database to make sure something exists. if Len(objSendEmail("file_name")) > 0 then objMailJ1.AttachFile strFile end if SHARETHIS.addEntry({ title: "Using LEN in asp", url: "http://code.netexceed.com/asp/using-len-in-asp/" });

Shows you how to change the display name in an email sent from asp. objMailJ1.From= "Jason Mohan <jasonmohan@nospam.com>" objMailJ1.To= "" & email_address & "" objMailJ1.Subject="New Code:: Activation Link" objMailJ1.BodyFormat=0 objMailJ1.MailFormat=0 objMailJ1.Body=html objMailJ1.Send SHARETHIS.addEntry({...

Shows you how to read the date fields in SQL or Access files through ASP. SELECT * FROM main_ca WHERE date_submit BETWEEN #MMdatefrom# AND #MMdateto# ORDER BY id_stamp DESC SHARETHIS.addEntry({ title: "Reading dates into SQL from ASP", url: "http://code.netexceed.com/asp/reading-dates-into-sql-from-asp/"...