display @@identity in alert box 2

[richey1]

hi

i have written an insert statement which then reults the id using

	Set MyRS = Server.CreateObject("ADODB.Recordset")
	MyRS.Open SQLstmt, dbconnSQL
	SQLstmt = "SELECT @@Identity FROM dbo.user_request"
	Set myRS = dbconnSQL.Execute(SQLstmt)
	varNewID = myRS(0)

how can i put the value in an alert box using javascript ?

thanks
ian

 

[jemminger]

<script type="text/javascript">
var myId = <%= varNewID %>;
</script>

-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }
i like your sleeves...they're real big

 

[rac2]

You must generate the Javascript dynamically. Just like you display facts pulled from the database on the web page, you can write lines of code in the Javascript.

Like so-

<script>
...
var NewID = <%= myRS(0) %>;
alert("Show me the new ID: " + NewID );
...
</script>

 

[richey1]

thank you both.............

 

[BillyRayPreachersSon]

If there is ever a chance that the ID will be non-numeric, then you will have to put string delimiters aruond it:

var NewID = '<%= myRS(0) %>';

Dan


[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]