|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
June 20th, 2004, 01:05 PM
|
|||
|
|||
search word in database
i want to search a word in a column of a table in my database (type: ntext). i use following stored procedure:
CREATE procedure zoekenOpWoord (@woord AS varchar(50)) AS SELECT * FROM documents2 WHERE tekst LIKE '%' + @woord + '%' GO in my asp-page: set rs = Server.CreateObject("ADODB.Recordset") rs.open "zoekenOpWoord(" & mWoord1 & ")", conn, adForwardOnly, adLockReadOnly, adCmdStoredProc but i always get this error: HTTP 500.100 - Internal Server Error - ASP error Internet Information Services Error Type: Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. Can anyone tell me what i do wrong?
|
|
#2
June 21st, 2004, 12:52 AM
|
|||
|
|||
|
Try giving single quotes for the parameter
rs.open "zoekenOpWoord('" & mWoord1 & "')", conn, adForwardOnly, adLockReadOnly, adCmdStoredProc
__________________
Regards,  Brightlight
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > search word in database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
