ASP SQL Server query question

Question

I am new to ASP. I've been coding with PHP for about 10 years now but just started ASP.

Here is my code:

Set rs = CreateObject("ADODB.Recordset") 
strStoredProcedure = "SP_AddHPOrderItem'" & empIdent & "'" 
rs.Open strStoredProcedure,strConnect, adopenForwardOnly, adlockoptimistic, adcmdtext

I am assuming that the variable RS("styleDesc") is coming from this query as I have found no reference to an RS, only rs. Not sure if variables are case sensitive in ASP.

My question is, is strStoredProcedure a function? Because I don't understand how this query can be made with the variable assigned the way it is.

How does SP_AddHPOrderItem'" & empIdent & "' constitute a query? There are no selects, inserts, updates, or anything like that.

If an expert could point me in the right direction if would be much appreciated.

Is there a specific reason you are starting asp, and not perhaps asp.net? — Kinexus
– Kinexus, Commented Jul 1, 2011 at 22:17

Andomar · Accepted Answer · 2011-07-01 22:27:51Z

1

The first statement of a SQL batch can be a stored procedure name; if so, SQL Server will execute it even if it's not prefixed with exec. So the net effect is if you send this to SQL Server:

exec SP_AddHPOrderItem 'empIdent'

answered Jul 1, 2011 at 22:27

Andomar

239k55 gold badges387 silver badges412 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP SQL Server query question

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related