[ASP] AW: [ASP] Re: [ASP]_per_asp_abfrage_ ausführen?_

[Marco Velo]

This is a multi-part message in MIME format.

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

hi
 
und was meinst du mit DeineSP ???

________________________________

Von: activeserverpages-admin@glengamoi.com im Auftrag von Zeljko Kvesic
Gesendet: Di 23.11.2004 15:56
An: activeserverpages@glengamoi.com
Betreff: [ASP] Re: [ASP]_per_asp_abfrage_ausführen?_



Hi
>Nun möchte ich folgendes. Eine diese Abfrage soll ausgeführt =
werden. Das Resultat soll danach im Web angezeigt werden. Kann mir =
jemand sagen wie ich sowas mache? Damit die Abfrage ausgeführt werden =
kann, braucht es einen Parameterwert. In meinem Fall wäre es die =
Kundennummer....
also zum Beispiel:
-------------------------------------------------------
Dim objRs
Set objRs = Server.CreateObject("ADODB.Recordset")
objRs.Source = "EXEC DeineSP " & Parameter
objRs.Open ,objConn

'das objConn also das Connection String sollte definiert
'sein
-------------------------------------------------------
Eine andere Möglichkeit wäre es über das Command Objekt,
und Parameter zuweisung.
hier ist ein Beispiel wie das Command Objekt einzusetzten
ist um eine Abfrage in MS SQL zu starten:
http://www.aspheute.com/artikel/20010326.htm

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


------_=_NextPart_001_01C4D25F.69D549E2
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64

eJ8+IiATAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAMAAAAEFXOiBbQVNQXSBSZTogW0FT
UF1fcGVyX2FzcF9hYmZyYWdlX2F1c2b8aHJlbj9fACARAQWAAwAOAAAA1AcLABgAFAA1ACcAAwBx
AQEggAMADgAAANQHCwAYABQANgAfAAMAagEBCYABACEAAABFODQ3NTgwOUZEQTA1NjQwQThBQjRB
OEVCNUU5OUZCQgBuBwEDkAYA9A8AADcAAAADADYAAAAAAEAAOQCjmAdLX9LEAR4APQABAAAABQAA
AEFXOiAAAAAAAgFHAAEAAAAuAAAAYz1DSDthPSA7cD1Db21jbGlmZjtsPVNJUklVUy0wNDExMjQx
OTU0MzFaLTE3AAAAHgBJAAEAAAAsAAAAW0FTUF0gUmU6IFtBU1BdX3Blcl9hc3BfYWJmcmFnZV9h
dXNm/GhyZW4/XwBAAE4AAAJnl2zRxAEeAFoAAQAAACYAAABhY3RpdmVzZXJ2ZXJwYWdlcy1hZG1p
bkBnbGVuZ2Ftb2kuY29tAAAAAgFbAAEAAABpAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAAAYWN0
aXZlc2VydmVycGFnZXMtYWRtaW5AZ2xlbmdhbW9pLmNvbQBTTVRQAGFjdGl2ZXNlcnZlcnBhZ2Vz
LWFkbWluQGdsZW5nYW1vaS5jb20AAAAAAgFcAAEAAAArAAAAU01UUDpBQ1RJVkVTRVJWRVJQQUdF
Uy1BRE1JTkBHTEVOR0FNT0kuQ09NAAAeAF0AAQAAAA4AAABaZWxqa28gS3Zlc2ljAAAAAgFeAAEA
AAA8AAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAAAWmVsamtvIEt2ZXNpYwBTTVRQAHplbGprb0Br
dmVzaWMuZGUAAgFfAAEAAAAWAAAAU01UUDpaRUxKS09AS1ZFU0lDLkRFAAAAHgBmAAEAAAAFAAAA
U01UUAAAAAAeAGcAAQAAACYAAABhY3RpdmVzZXJ2ZXJwYWdlcy1hZG1pbkBnbGVuZ2Ftb2kuY29t
AAAAHgBoAAEAAAAFAAAAU01UUAAAAAAeAGkAAQAAABEAAAB6ZWxqa29Aa3Zlc2ljLmRlAAAAAB4A
cAABAAAALAAAAFtBU1BdIFJlOiBbQVNQXV9wZXJfYXNwX2FiZnJhZ2VfYXVzZvxocmVuP18AAgFx
AAEAAAAbAAAAAcTRa+ceYeRHBn3WSc+e8HxrWv2H5AA82PoZAB4AdAABAAAAIAAAAGFjdGl2ZXNl
cnZlcnBhZ2VzQGdsZW5nYW1vaS5jb20AHgAaDAEAAAALAAAATWFyY28gVmVsbwAAHgAdDgEAAAAs
AAAAW0FTUF0gUmU6IFtBU1BdX3Blcl9hc3BfYWJmcmFnZV9hdXNm/GhyZW4/XwACAQkQAQAAAMoI
AADGCAAArhsAAExaRnXA2teZAwAKAHJjcGcxMjWCMgNDaHRtbDEDMD8BAwH3CoACpAPjAgBjaMEK
wHNldDAgBxMCgP8QAwBQBFYIVQeyEdUOUQMB3RDXMgYABsMR1TMERhDZWRLvZjQDxhGKNRBvIPhU
YWgDcQKAEeMI7wn39jscHw4wNR0/HRER4QxgzmMAUAsJAWQzNhFgC6VkNCAQAipcDrIBkGcvFPAK
oxHjImg0FPA8IQBET0NUWVBFIABIVE1MIFBVQgBMSUMgIi0vL4hXM0MmAERURCUUCDMuMiYARU4i
PucjbSMPKEExOCRwJSInjxsonysQMyIAKfBFQURfKk0O8StvLe8pdDYO8DxQTUVUQQewQTDgPUwi
RwnwBJBhdAWwItEXEE9OVCdQVDFwBeFERXgQ8W5nZQZSdg8TMTPBAJACICA2LjXqLgHAMjSAMCd+
L08pgwQ3NyRwVElUTEUFKk40DvBbQVNQXUkH8GU6OTRfcASQX2hhc3A6cGIDUCsQZcE6cHVzZlwn
EOEeoKhuP18o7jUkcC83z381/yrFORE9QCzPKx9BFDXBEWA8Qk9EWUCNIXERQa9nOTYkcERJVhAg
aWQ9RgBPV0EDOaALUHlUZXh0MwIyRYAzIGRpcj3dQTByQIBA8wAhIAAAR7HnCrFIohDwXHEDIUgV
EWB/Q29Ef0WGR39Ij0maQMk2rjRNeknPKXQ0KdFGMlGkIGYA0GU9BxMgG5OoPSMwVIMgAJB6U5Du
Mk1rGDADMGMT8AOyAdCpSaloaSj8NUWRL1MS/01pTXdPuwHATXcKolnoCoD9KPwwLJEmYEXQWT9R
r0sf/0wvTT9OT1ofUG9fP1KPU5Z/VP9WBFa9V89Y318PQQU48SIAJm5iOpACgGLnO4D+YQFAZK9b
H1wvXT9eT25P/2BvYX9ij2OfcP9lv3YfZ98HaO9p/1bbdW5kIHctOoAgB4ALgHMFQGR11YMwaQVA
RINRZTlgIhz7VjF3oz+F8GvfbO9Z73Hv/3L/dA91H33Pi++M/3afd69veL95z3rfkJ8xDiBC4VI/
k+kKogqBlc+RX5JrSFIaIAGRSYLQRuA9LTFLgMwAUHEA4HFqDGBsxGRiAzB+IF+eYp4h/5SghEGK
U5iPmZ58L30/fk//f1kaxIBfVfI9IGrfbr1C8NeT654Rp7dWAiA6mpwkYZYvqVqISSAA0HRpM8AP
ETAzsgqwM2BzLWFkIYPgbkBnbAnwZ2HpBGBpLgWgbUXwsBCEr3maUkF1AYA68TPwNFFagGVsamtv
IEuuEf8N4JZdRZGXfJ7yn4+on6mv77YCMZARMJwRdKsvrD+tR/BEaSAyJwCXICcQVID7IgCG8DqH
ALNPtF+1b7Z/+7ePv/RBqx+6f604sG+aUv+t369MvV++b79/wI/Bn8u0/kIRQB6gASDDL8Q/rUc5
SP/F35pSOe86/zwAyR/KL8s//4Zfh2/Yn9av17+Ir4m/is//jp/av6Avmj9FZ5Pr43/kj/uhuSRw
UJef51jmv9u/fyf3pe8B8VbMSFe93M/d326v1Gd0b/k+82hOgsCDMLU7gTYQ8HQzcA3gaFNQ5wbw
M2CcEXMuMvCEQZNh/64hEXDUxO6wBvADINKPxuNvO1AzYDt1BUB3BJABAG7t+EBEgxE5oHOd4AGQ
BUA9+ZNkAHAA0PeQsDFXZbeeEDNC7uBp9RD8B0sNsM/2sZOA+d/o82plA4GC4P5z1PEDoAPw91T5
kIMD/eH8ZT/8gYPi+LH5B/s//EG0IGv/wSwAP+jzYjHQeyAADrAgrsAIQIRB9rBQ3wrAA8ARQBZA
/BF0+ECcALODMwGgIEZT4JWQdzuAfGU0HqAIQgQSBo/pAksjgsEcoG51bYNAci4/DcHxD/If8yxT
4PmQIHpfDXALr+jzzsAZ4HD4wGznzzwO3w/vIC0WfxePGJ9/GNETfxSP8yy8IBF/6ORv8GJqUnMZ
7xr/8ywzkJOEAB5zID0zhS5DzvApMeBlTx6AZa3gKCLzQGBDEEIuOaDI4AXQ+OB4dCIpHs8f3/Ms
HnMu+FNvdZVAM3AiYB0v6QLgIkVYRUOEFzIg9A/7A8Bv6iatKQjnJO8l/ycPrSgRT9Qw9rAsHnFD
NFB+bi5vL3/zLzLPM9806Sf//bCDIDIlEPQo3+kCOKIyUvUjgWmyQVOTwK8gshD5kv/3QTm/OsPP
AK8g+MDgEDWf/zavN7344K8gPr8/zxWfRS//Rj9HTxnfQw80rfhjPN/G47ucEQsRTfbir1D3cWv+
4Pf78QrYBTJirnD9oTsiDYDjAcIjUmt0LEh/SY80vP+CwgjnS7/o8xFQ/BATAILA7mcN/1HfNK1o
PnGwIIOB/4NRzrETBAJTT69aExFQJJH+evdAQf9XrzStWfJUv+kCTxFhhDL5B1pBTVMicFH+TBFB
7rCb0OAQ1dATb14/GzSvzD1B6NTVsWY9IoH1YHRwOi8vd2lgti7UcQNwdfdAr+IvY7EyaU4gbC+8
seIQMzK0Ni71YSKAzBMxZGCSBmad8INie0hZUEXgUkxJTksq8Gj/ag9Naxl9oYFtIXJzKWBc/mOd
UZ3gp5luX29vaxjiz/fr6uNfz6pBZVBkH2UvZj9Heb96z3vZR3J1BTBkzmZ8j32fe6x6a3//gQ+l
e6wBBTBiZAUwYe7wx4Yh4RH0LSM4Mpcg9Tm/BTDmIHvvh2+If4mEeIYhE4kwhjAydYnvIzMznjmL
TJ2QiV+N+TUyi0uMOGGCWYZhY3p6kF/dkWEzi0ySiYZhMgUyk59/jnGLAItMnyBTSJcfivEz2jCR
rDWPv4pcN4tMlrCfnG+Xn5ivkvWNAmMzn+/vivFrUItMnElqLlyKtO4w/aEtOZ9Ppt+n76j/ip+L
r++sL5FPklwFMWSvP7BPkn7/e7HZP9pPxT8pTN/P4NXqj/+uv99U0DHqUeFP4l+8L+hvu8EPeXw1
7kHQUCPwWXltF9Agwx/FoTfQMUhUTQpMhFB9x9AAAB4ANRABAAAAOgAAADw0RkFDOTA1NEMzMEUx
NjRBQjYzOEY4QzE2RTc3QjE4NUYyRDVAc2lyaXVzLmNvbWNsaWZmLmNoPgAAAB4ARxABAAAADwAA
AG1lc3NhZ2UvcmZjODIyAAALAPIQAQAAAB8A8xABAAAAdAAAAEEAVwAlADMAQQAgAFsAQQBTAFAA
XQAgAFIAZQAlADMAQQAgAFsAQQBTAFAAXQBfAHAAZQByAF8AYQBzAHAAXwBhAGIAZgByAGEAZwBl
AF8AYQB1AHMAZgD8AGgAcgBlAG4AJQAzAEYAXwAuAEUATQBMAAAACwD2EAAAAABAAAcwo5gHS1/S
xAFAAAgwfmbbaV/SxAEDAN4/r28AAAMA8T8HCAAAHgD4PwEAAAALAAAATWFyY28gVmVsbwAAAgH5
PwEAAABeAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPUNPTUNMSUZGL09VPUZJUlNU
IEFETUlOSVNUUkFUSVZFIEdST1VQL0NOPVJFQ0lQSUVOVFMvQ049TS5WRUxPAAAAHgD6PwEAAAAV
AAAAU3lzdGVtIEFkbWluaXN0cmF0b3IAAAAAAgH7PwEAAAAeAAAAAAAAANynQMjAQhAatLkIACsv
4YIBAAAAAAAAAC4AAAADAP0/5AQAAAMAGUAAAAAAAwAaQAAAAAADAB1AAAAAAAMAHkAAAAAAHgAw
QAEAAAAHAAAATS5WRUxPAAAeADFAAQAAAAcAAABNLlZFTE8AAB4AMkABAAAAJgAAAGFjdGl2ZXNl
cnZlcnBhZ2VzLWFkbWluQGdsZW5nYW1vaS5jb20AAAAeADNAAQAAABEAAAB6ZWxqa29Aa3Zlc2lj
LmRlAAAAAB4AOEABAAAABwAAAE0uVkVMTwAAHgA5QAEAAAACAAAALgAAAAMAdkD/////CwApAAAA
AAALACMAAAAAAAMABhCklWzUAwAHELIDAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABlAAAASElV
TkRXQVNNRUlOU1REVU1JVERFSU5FU1A/Pz9WT046QUNUSVZFU0VSVkVSUEFHRVMtQURNSU5AR0xF
TkdBTU9JQ09NSU1BVUZUUkFHVk9OWkVMSktPS1ZFU0lDR0VTRU5ERQAAAAACAX8AAQAAADoAAAA8
NEZBQzkwNTRDMzBFMTY0QUI2MzhGOEMxNkU3N0IxODVGMkQ1QHNpcml1cy5jb21jbGlmZi5jaD4A
AAAHag==

------_=_NextPart_001_01C4D25F.69D549E2--