Webmaster-Talk.com - ASP Forum http://www.webmaster-talk.com/ ASP coding, i.e. Active Server Pages, discussions and help. en Fri, 20 Nov 2009 23:45:07 GMT vBulletin 60 http://img.webmaster-talk.com/bluesky/vb_img/misc/rss.jpg Webmaster-Talk.com - ASP Forum http://www.webmaster-talk.com/ My Insert statement needs a trim http://www.webmaster-talk.com/asp-forum/191770-my-insert-statement-needs-a-trim.html Mon, 16 Nov 2009 10:01:40 GMT Hi, I have an insert statement that i need to refine...basically I need to trim the first couple of letters of whats trapped in the field. so... Hi,

I have an insert statement that i need to refine...basically I need to trim the first couple of letters of whats trapped in the field.
so e.g.

Z:\aaa\1.jpg

needs to become

aaa\1.jpg

I've tried this but its not working

HTML Code:
sImagelink = mid(request.form("Imagelink"),4,len(request.form("Imagelink")))
any ideas? ]]> ASP Forum The Mighty Dub http://www.webmaster-talk.com/asp-forum/191770-my-insert-statement-needs-a-trim.html VBSCRIPT from sql 2000 to sql 2008 http://www.webmaster-talk.com/asp-forum/190941-vbscript-from-sql-2000-sql-2008-a.html Thu, 05 Nov 2009 11:41:36 GMT Hello all,

I have a VBSCRIPT that works perfect with SQL 2000 but doesn't work with sql 2008 . any help please?

<%
dim rs, strSQL, action, id
dim headline, news_date, copy, sub_heading, author

id = trim(request.form("id"))
headline = trim(request.form("headline"))
sub_heading = trim(request.form("sub_heading"))
news_date = trim(request.form("news_date"))
author = trim(request.form("author"))
copy = trim(request.form("copy"))
headline = Replace(headline, "'", "''", 1, -1, 1)
news_date = Replace(news_date, "'", "''", 1, -1, 1)
author = Replace(author, "'", "''", 1, -1, 1)
copy = Replace(copy, "'", "''", 1, -1, 1)


set rs = server.createobject("ADODB.RECORDSET")

if id = "" then
'Insert record
strSQL = "insert into tbl _news (headline, sub_heading, news_date, author, copy) values ("
strSQL = strSQL & "'" & headline & "', "
strSQL = strSQL & "'" & sub_heading & "', "
strSQL = strSQL & "'" & getLongDate(news_date) & "', "
strSQL = strSQL & "'" & author & "', "
strSQL = strSQL & "'" & copy & "')"
else
'Update the record.
strSQL = "update tbl _news set "
strSQL = strSQL & "headline = '" & headline & "', "
strSQL = strSQL & "sub_heading = '" & sub_heading & "', "
strSQL = strSQL & "news_date = '" & getLongDate(news_date) & "', "
strSQL = strSQL & "author = '" & author & "', "
strSQL = strSQL & "copy = '" & copy & "' "
strSQL = strSQL & "where id = " & id
end if
dCmd.CommandText = strSQL
dCmd.CommandType = 1
set rs = dCmd.execute

set rs = nothing
set dCmd = nothing

response.redirect("main.asp")
%> ]]> ASP Forum cafeolai http://www.webmaster-talk.com/asp-forum/190941-vbscript-from-sql-2000-sql-2008-a.html <![CDATA[JScript error, Expected ';' but where?]]> http://www.webmaster-talk.com/asp-forum/190772-jscript-error-expected-but-where.html Tue, 03 Nov 2009 19:04:19 GMT Hi all, I recently found some code that allowed me to display a random image without having to name the images a specific name.... Hi all,
I recently found some code that allowed me to display a random image without having to name the images a specific name. Instead I could just throw in an image to a directory and the JavaScript will just pick an image randomly. Testing the code I find it is not happy with the syntax, and although it has narrowed it down to a line and a clue, having placed the ';' in various positions the same error continues to bug me. The error message is quoted below, can anyone please point me in the right direction?

Error Type:
Microsoft JScript compilation (0x800A03EC)
Expected ';'
/bigdogz/rndm.asp, line 12, column 6
Const IMGS_DIR = "/miscimages/";
-----^
Thanks in advance,
Mitch... ]]> ASP Forum CMitch07 http://www.webmaster-talk.com/asp-forum/190772-jscript-error-expected-but-where.html Possible SQL Injection attack...i think!!! http://www.webmaster-talk.com/asp-forum/189820-possible-sql-injection-attack-i-think.html Thu, 22 Oct 2009 15:49:13 GMT Hi, I just came across a piece of script that has been put into my source code throughout the site...and not by me!!!. Im using ASP pages and sql... Hi,

I just came across a piece of script that has been put into my source code throughout the site...and not by me!!!. Im using ASP pages and sql 2000 db.

Im not sure how they did it but im fearing this could get more serious and end up them hitting my db. Here is example(kind of) of the script im finding...

Code:
<script src="Http://www.domainname.com /a /a .php></script>
HELP!!!! ]]> ASP Forum The Mighty Dub http://www.webmaster-talk.com/asp-forum/189820-possible-sql-injection-attack-i-think.html