[ASP] AW: [ASP] Re: [ASP] AW:_[ASP ]_Re:_[ASP]_per_asp_abfrage_ausfüh ren?_

[Marco Velo]

This is a multi-part message in MIME format.

------_=_NextPart_001_01C4D31A.B510B1DC
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

hallo
 
Ich komme einfach nicht mehr weiter! Wenn ich nun ne SQL-Abfrage =
schreibe, dieser braucht nun einen Parameter um die ausführung der =
Abfrage zu beenden. Wie mache ich das, ich komme wirklich nicht weiter. =
Mit StoredProcedures bin ich eher noch schwach. Hat jemand nen guten =
tutorial??
 
So sieht im moment mein code aus!
 
<%
 Dim Conn, rs, user_id, password, kd_nr
 
 user_id = Request("user_id")
 
 Set Conn = CreateObject("ADODB.Connection")
 Conn.open = "Provider=SQLOLEDB.1; " &_
 "Data Source=Tritis; Initial Catalog=Hof_Design; User id=" & =
user_id & "; Password=" & Request("password")
 
 Dim sqlCommand
  sqlCommand = "SELECT Mitarbeiterdaten.KdNr, " &_
      "Struktur.Stufe, Stufen.St_Text," &_
      "FROM Stufen " &_
      "INNER JOIN (Struktur INNER JOIN Mitarbeiterdaten ON Struktur.KdNr =
= Mitarbeiterdaten.KdNr) ON Stufen.St_Nr = Struktur.Stufe "&_
      "WHERE (((Mitarbeiterdaten.KdNr)=[kd_nr]));"
 
  
 'Objekt zuweisen und Connection zum SQL Server
 Set rs = CreateObject("ADODB.Recordset")
 RS.ActiveConnection = Conn
  
 Cmd.CommandType = adCmdStoredProc
    Cmd.CommandText = "Strukturliste_Struktogramm"
    rs.source = "EXEC 
    
    ' Records anzeigen
  RS.open
 
 
 %>
 
 
 
 

________________________________

Von: activeserverpages-admin@glengamoi.com im Auftrag von Zeljko Kvesic
Gesendet: Mi 24.11.2004 23:20
An: activeserverpages@glengamoi.com
Betreff: [ASP] Re: [ASP] =
AW:_[ASP]_Re:_[ASP]_per_asp_abfrage_ausführen?_



Hello Marco Velo,



Best regards,
 
======= At 2004-11-24, 20:53:39 you wrote: =
=======

>hi
>
>und was meinst du mit DeineSP ???
>

damit ist die Stored Procedure im MS SQL Server gemeint,
zum Beispiel insUser den Namen vergibst Du ja beim anlegen
einer Prozedur (CREATE PROCEDURE DeineSP ..)

Gruß
zk
=01=BD=AE==B0--x=B6=B2uoeSz=ACzzs=A2üzzu...'zz=B6=C3*jr(tm)(tm)-S=FDS=
z=AE 


------_=_NextPart_001_01C4D31A.B510B1DC
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64

eJ8+Ig4SAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEARAAAAEFXOiBbQVNQXSBSZTogW0FT
UF0gQVc6X1tBU1BdX1JlOl9bQVNQXV9wZXJfYXNwX2FiZnJhZ2VfYXVzZvxocmVuP18AWBcBBYAD
AA4AAADUBwsAGQATAAsAOgAEAFsBASCAAwAOAAAA1AcLABkAEwAPAA0ABAAyAQEJgAEAIQAAADc2
MDgxNjgyMTM4QzhFNEE4RDRGMUYxRUU2NzhFMkQ0ADMHAQOQBgD4FQAANwAAAAMANgAAAAAAQAA5
AOOJI0Ea08QBHgA9AAEAAAAFAAAAQVc6IAAAAAACAUcAAQAAAC4AAABjPUNIO2E9IDtwPUNvbWNs
aWZmO2w9U0lSSVVTLTA0MTEyNTE4MTUxM1otMTgAAAAeAEkAAQAAAEAAAABbQVNQXSBSZTogW0FT
UF0gQVc6X1tBU1BdX1JlOl9bQVNQXV9wZXJfYXNwX2FiZnJhZ2VfYXVzZvxocmVuP18AQABOAAC/
ONNz0sQBHgBaAAEAAAAmAAAAYWN0aXZlc2VydmVycGFnZXMtYWRtaW5AZ2xlbmdhbW9pLmNvbQAA
AAIBWwABAAAAaQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGFjdGl2ZXNlcnZlcnBhZ2VzLWFk
bWluQGdsZW5nYW1vaS5jb20AU01UUABhY3RpdmVzZXJ2ZXJwYWdlcy1hZG1pbkBnbGVuZ2Ftb2ku
Y29tAAAAAAIBXAABAAAAKwAAAFNNVFA6QUNUSVZFU0VSVkVSUEFHRVMtQURNSU5AR0xFTkdBTU9J
LkNPTQAAHgBdAAEAAAAOAAAAWmVsamtvIEt2ZXNpYwAAAAIBXgABAAAAPAAAAAAAAACBKx+kvqMQ
GZ1uAN0BD1QCAAAAAFplbGprbyBLdmVzaWMAU01UUAB6ZWxqa29Aa3Zlc2ljLmRlAAIBXwABAAAA
FgAAAFNNVFA6WkVMSktPQEtWRVNJQy5ERQAAAB4AZgABAAAABQAAAFNNVFAAAAAAHgBnAAEAAAAm
AAAAYWN0aXZlc2VydmVycGFnZXMtYWRtaW5AZ2xlbmdhbW9pLmNvbQAAAB4AaAABAAAABQAAAFNN
VFAAAAAAHgBpAAEAAAARAAAAemVsamtvQGt2ZXNpYy5kZQAAAAAeAHAAAQAAAEAAAABbQVNQXSBS
ZTogW0FTUF0gQVc6X1tBU1BdX1JlOl9bQVNQXV9wZXJfYXNwX2FiZnJhZ2VfYXVzZvxocmVuP18A
AgFxAAEAAAAbAAAAAcTSc6QAxUd+JH/fSsCc45wE7hm7VQApp0ghAB4AdAABAAAAIAAAAGFjdGl2
ZXNlcnZlcnBhZ2VzQGdsZW5nYW1vaS5jb20AHgAaDAEAAAALAAAATWFyY28gVmVsbwAAHgAdDgEA
AABAAAAAW0FTUF0gUmU6IFtBU1BdIEFXOl9bQVNQXV9SZTpfW0FTUF1fcGVyX2FzcF9hYmZyYWdl
X2F1c2b8aHJlbj9fAAIBCRABAAAAYQ4AAF0OAACXOQAATFpGdQqWhIQDAAoAcmNwZzEyNYIyA0No
dG1sMQMwPwEDAfcKgAKkA+MCAGNowQrAc2V0MCAHEwKA/xADAFAEVghVB7IR1Q5RAwHdENcyBgAG
wxHVMwRGENlZEu9mNBBvEXs1GF8g+FRhaANxAoAR4wjvCff2Oxy/DjA1Hd8dsRHhDGDOYwBQCwkB
ZDM2EWALpWQ0IBACKlwOsgGQZy8U8AqjEeMjCDQU8DwhAERPQ1RZUEUgAEhUTUwgUFVCAExJQyAi
LS8viFczQyagRFREJbQIMy4yJqBFTiI+5yQNI68o4TE4JRAlwigvGyk/K7AzIqAqkEVBRF8q7Q7x
LA8ujyoUNg7wPFBNRVRBB7BBMYA9TCJHCfAEkGF0BbAi0RcQT05UJ/BUMhAF4URFeBjhbmdlBlJ2
DxMxNGEAkAIgIDYuNeouAcAyNSAwKB4v7yojBDc3JRBUSVRMRQUq7jQO8FtBU1BdCQfwZTo51UFX
Ol8tOeNfOkE7FXAEkF9htHNwPFBiA1ArsGU8UGB1c2ZcJxjRH0Bu1D9fKY41JRAvOG82n78rZTmx
PyAtbyu/QvQ1EWDgPEJPRFlCbSIRQ48IZzk2JRBESVYgiGlkPUfgT1dBOkABC1B5VGV4dDQzhDM5
DvBkaXI9QxDuckJgQtMAISAAAEmRCrHzSoIY4FxxAyFJ9RFgRU8/Rl9HZklfSm9LekKpNjRXT1pL
ryoUNCpxRjLxIFJmANBlPQcTIBwzPVQjMFZjIACQelVwMvdPSxgwAzBjE/ADsgHQS4mtGPBsHFAp
nDVHcS9U8v9PSU9XUZsBwE9XCqJb+AqA/SmcMC0xJwBHsFtPU49M//9OD08fUC9cL1JPYU9Ub1V2
f1bfV+RYnVnfWu9hH0LlOPEioCZuYjxwAoBk9z1g/mEBQGa/XS9eP19PYF9wX/9if2OPZJ9lr3MP
Z894L2nvl2r/bA9Yu0kY4CBrA3D5B4AgZQuAVUGE8AMAGOCnBUAHgD2gIHeFcHQEkPghIFcJ8AOg
QQx5lYYBHYXgdQOgMlAGAFFMLQ5BPLSCYD2SaWJlLPd7QQeQEzFiMnAgoIYhiQJvhXEJ8CYACsBh
B4CG0SB8dW2KwodvebM9KIkQZ+d7QBMxibZ6dYswCeEBANxuLocQjUEAwWg0EIjCPmQ8YIqwiMKF
FAPwcmt+bIjDhgONf3nChqSRAE1vhsAGADKRCYBQA2BVYGR7CHAHkWILgJGzhmATMW63lnCE8Iox
d4WxkQBIMoBoIGplA4FkiTEDoGfudYbQh195pHSZsAWwBzH8Pz9t727/W/9z/3UPdh//dy9/33lP
el97b3x/fY9+n/9/r4C/gc+C32z/nB+dL69//3E/ck+ej5+foK+hv7G/o9//pO+l/6cPqB+pL6o/
up+sX+etb65/wfZTb8SBhmAFQP8HcIZAA3AJ8IYylxEFoAEA+5n/jnYhsA+xH54fth+3L/+4P7lP
wf+7b7x/vY++n7+v/8C/wc/C38PvxP+vH8p/y4//3d+zX7RvzO/N/88P0B/gH//SP9NP1F/Vb9Z/
14/Yn+j/1+ICQxDiiTzwOCUpnDEw/UTBUuxJ7QCMEQqB8E/hv/viz/YyRMeBCFCHQIqwGRB/irA9
MDwxR+CKsAqwBBB3DwWw+pHIz+pCa2Rfbv5y83/0j/Wf9q/3v/9//Y+f/p8CjwC/Ac/6JiA9OjFC
cR2gc3QoIvo1Iv4pAu8D/wUPBh8HLwz/Cw//DB8QDw4/D080IZPP6iT5ko0JMUMfQDKAZU9imPDO
YwnBQkBE8EIu+ZIY0f804QpvEV8SbxN/FI8PufmSvC5vPCAYAhaP6kIillHWdgkQNLA9iXFPP3AZ
UWwxOyZwHT8mjJAeiib9HKhfGk8bXxxvHX8ejyjXdCJEMoBhxuGWsFVhVOubkBngcyNwSYXwGeBV
wQ8g7xeTLGFWEGc9SG+IZl9EltBpZ24jcP5ViwJH4SOfJK8oyAi3MU/7Ml8zZyIjcIxg+uQxHzVf
/zM6Lh/qQgln+sYaLydfKG//KX8qjw+/PZ8+r0KfQM9B3/35JXNLYBfQhTCZIUMfRC//RT9GT0df
TE9NX05vT3JJOEc6r+ozCUAiU0UjEEN/2zCVsepAipCGwpIAmcEu8EtkTnKKsDfvOP8lv/9KP0tP
Tz9QT1FfXE9dX15v/19/YI9hn2KvY79kz2XfZu/vUz8h5JXwj1Brm1CVgJXwPHVmiqFs05DwlfBf
VPBleHQsVq9Xv1jPWd//Wu9nf2iPaZ9z33Tvdf93D/94H3kvej97T3xffW9+f1aQ8EZST01q3+oz
bURWn/9vP3BPcV9yb37/gA+BH4ov/4s/jE+NX45vj3+Qj5Gfkq8Hk7+UzzcBSU5ORVLIIEpPmOAg
KGxGLYDfmPOC3+pCmUNVPiDbEG0x32xlVkIJMVU/VkIpnTRtZv+eIZqfVFRsTISAle+Fz4bf/4fv
iP+Vj5afl6+o/6oPqx//rC+tP65Pr1+wb7F/so+X37RXSJkQRaDf6jMouTATnn+fgz1b/LNdKSn+
O6NMpt+n77R/tY+zv7vP/7zfwM++/8APxB/FL8Y/wW/fwn/Dj8d/yI/MlycYomyA47ff6jN6dXec
kDCwIKD2dVMRGYgg0dD5cCLRFjH8cnYwwMovyz/MT81fzm9/Fbv58CC/F2YYXxlgPABj+zzhMLB0
PR/VL9Y/10/YX+HJeVJTLkEZ0dQA0qn/2o8XeN3v3v/gD+Ef4i/pL//qP+tP7F/nj+if7I/tnx9c
zG1kGXFJg1R5IIDk/zkhxWFk9VFsQDzgZWT9IkFj73/wj/Gf8q/zv/sv//w//U/+X/9vtm/1Wm3x
9k9na876sAmwZV9sRC+wcsmkYG0iBak3MgLXIdItAtcw+LD4vDCkMDwv+ERJVvn5CjjvbO9QIdSN
+Ls5+aEMISBkaSKwfSFwcvn5BaAQkdGBEYJjPGhcSUD6kA0nBak2NP8Q2g0vAf8DDxUfFi8XPxhP
ZxlfairaUC5zLLOeQSL8RVhU8O9v+b/6zxs/HE//IY8inyOvJL8lzybfBX8Ov/8f7yD/J88o3ycP
L18wbzF/tzKPM5+CIyfjsN1EIEmg+nqckGdWECwvLT8uTzUf1zYvgdjjwW/2IG4Inwmv/wq/C88M
3w3vDv8QDxEfEi//Ez8UTzv/PQ80LzlPOl9Ob/9Mn02vUb9Pz1DfUe9S/+L70iVX32d0WSk+SV8/
z/9A30HvQv9Xb0UfRi9HP0hP/1y/Sm9h31hPWV9dD14fXy//YD9hT2JfY29kf2WPZp9nr/9ov3HP
at9r72z/bg9vH3Av/3E/ck9zX3RvdX92j3efeK//eb96z3vffO99/38PgB+Iz/+CP4NPhF+Fb4Z/
h4+In4mv/4q/lm+M343vjv+QD5i/nw9/oB+Rj5Kfk6+Uv5XPVN0yH1Xe0YFXH6QPpR5IUiAZVXBi
SdJwBSA9LTEppstmMZXwY5XwalwQdWxkYlawfiBf/7FCsQFWw50zq2+sfpbfl+8JVNw0OFXQRk9O
VAggZmEecD1UYWgh9aBhIHNpOJA9MsWvbDVWsGZzMqzxtg9fW0ZV4KbLsPG6l1bmgDr7rXyqIS+8
OqMJOGDkA9Igp9Py0YA4wHMt98BtVuAoQGdsPzBnCFBvaXYu3VDTcGnTcCrfBpJBTHVmBvBVgCB2
0yFagGVsamtvIEvA8X5p+K9V31bvu0+8X8i1RzvBAa7xdL4Pvx83R01p0CAyNC7G8C66UKHR+DIz
OrpQxi/HP8hPyV/7ym/S1EG9/81fKj/27cDOf8Is0D/RT9Jf02/Uf96UQnPMMPhAZmbWD9cfN0db
0EFTUF034Trktdi/0cRTVzpf5MNf5SHnRTH2IHJfYZog6IBiZiPE0QegYXVznSAnZuOV0PhAbj9f
2//dD94f9eppNeshL7ey41/s7+r//+wPm7+cz53foa/vD7M/rU+/peSmy/ef+K+0mfEAUKp/f/t4
+t/v37d3uM+wEbpMSPXFYGzFoE0GkDgQvcDFYPxvLPAP8R/sXwZPB18Ibz8JfwqPC58Mrw2/4VVz
dP/lv7Qj4dDCcDgxBg8QHw4vv5kfmi8WnxSvFb8ZpT0dFE/V0BJAz5KvQDEtzzAsCR2xOjXP8DM5
IHmAb3Ugd3JvdOUx/xJv5tIdFRofGy8WXyG/Is/HI99bL1w/IGhpJI8ln/8mrye/KM8s/ysPLB8t
Ly4/nTJGdcwQH0DokCBtOKC6bhIxZB8wwfASQEQ14e5l5OAfv7QjPziAL88w3/8x7zL/NA87fzmP
Op8+Pz9PLUBdZNtwNoFpNhJpZbAgU3Rv4dA1cFAfYE+4IDZA4dDDAk1TRRBRfkxFEMEjNy+0I8GQ
NdJ05xQvQk9AXXp1wvDhoESg7nBE8KhwNfFVwRGmQMwAnCBO23BNccFBZ2kYUGs2kR8warigYjbA
wvBh9m7CQMGQbkkfSi9AbDbCH0cv5rRFkQMAReEgKEMgUkVBVEVFgFJPcENFRFVVEDav5ksu/C4p
T79Qz0BvWE9ZX1ppyEdydRkwZGZbH1wvXUs9a16PX59aPAEZMGI+ZBkxuDBksdAsPIIjOP4yYnAY
i6XQWn9l/2cPaBROeGSxZ8BkwDJ1aH8jPjMe4GncsHBn72yJNTIZGIs4YUt5GTFjenq7bu9v8TNp
3HEZGTEy6ZL/ci9tAWmQadyyADTIda9pgbQzMHA8NW5PaOw3adw/dUB6/3Yvdz9xhWuSYzOzfn9p
gTI2adx62WqrUfeCD7dwf705fd+Fb4Z/h4+/aS9qP4q/b99w7OmRZI3P/47fcQ5aQe1f7m/YH+Y8
8+//9PX+r41P83T2Yf5x9W/2f2+av/yPn5/5bDW3geMwT7xEWZyNqiChr6QxN52hUEhUTUxi4H2m
YAAAAB4ANRABAAAAOgAAADw0RkFDOTA1NEMzMEUxNjRBQjYzOEY4QzE2RTc3QjE4NUYyRDZAc2ly
aXVzLmNvbWNsaWZmLmNoPgAAAB4ARxABAAAADwAAAG1lc3NhZ2UvcmZjODIyAAALAPIQAQAAAB8A
8xABAAAApAAAAEEAVwAlADMAQQAgAFsAQQBTAFAAXQAgAFIAZQAlADMAQQAgAFsAQQBTAFAAXQAg
AEEAVwAlADMAQQBfAFsAQQBTAFAAXQBfAFIAZQAlADMAQQBfAFsAQQBTAFAAXQBfAHAAZQByAF8A
YQBzAHAAXwBhAGIAZgByAGEAZwBlAF8AYQB1AHMAZgD8AGgAcgBlAG4AJQAzAEYAXwAuAEUATQBM
AAAACwD2EAAAAABAAAcwvAIiQRrTxAFAAAgwn1UYtRrTxAEDAN4/r28AAAMA8T8HCAAAHgD4PwEA
AAALAAAATWFyY28gVmVsbwAAAgH5PwEAAABeAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAA
AC9PPUNPTUNMSUZGL09VPUZJUlNUIEFETUlOSVNUUkFUSVZFIEdST1VQL0NOPVJFQ0lQSUVOVFMv
Q049TS5WRUxPAAAAHgD6PwEAAAAVAAAAU3lzdGVtIEFkbWluaXN0cmF0b3IAAAAAAgH7PwEAAAAe
AAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC4AAAADAP0/5AQAAAMAGUAAAAAAAwAaQAAA
AAADAB1AAAAAAAMAHkAAAAAAHgAwQAEAAAAHAAAATS5WRUxPAAAeADFAAQAAAAcAAABNLlZFTE8A
AB4AMkABAAAAJgAAAGFjdGl2ZXNlcnZlcnBhZ2VzLWFkbWluQGdsZW5nYW1vaS5jb20AAAAeADNA
AQAAABEAAAB6ZWxqa29Aa3Zlc2ljLmRlAAAAAB4AOEABAAAABwAAAE0uVkVMTwAAHgA5QAEAAAAC
AAAALgAAAAMAdkD/////CwApAAAAAAALACMAAAAAAAMABhBolwQ+AwAHEG8FAAADABAQAAAAAAMA
ERAAAAAAHgAIEAEAAABlAAAASEFMTE9JQ0hLT01NRUVJTkZBQ0hOSUNIVE1FSFJXRUlURVJXRU5O
SUNITlVOTkVTUUwtQUJGUkFHRVNDSFJFSUJFLERJRVNFUkJSQVVDSFROVU5FSU5FTlBBUkFNRVRF
UlVNRAAAAAACAX8AAQAAADoAAAA8NEZBQzkwNTRDMzBFMTY0QUI2MzhGOEMxNkU3N0IxODVGMkQ2
QHNpcml1cy5jb21jbGlmZi5jaD4AAAD2GA==

------_=_NextPart_001_01C4D31A.B510B1DC--