![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| Hi, I made a stored procedure (name = test (Out param1 char(20)) in Mysql 5.0 with a parameter. I use ASP (i know PHP would be maybe a better choice but it's ASP) and the value of the parameter must be compared to the value of variable 'name' for identification. I can get the records from a stored procedure without parameter in ASP, but here, I don't know how to link variable 'name' to the stored procedure. Thanks Kevin The code: <% name="bibi" set objdc = Server.CreateObject("ADODB.Connection") objdc.Open "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306; Option=0; Socket=; Stmt=;" Database=reserv; Uid=root; Pwd=xxx;" set rs=objdc.execute("call test3 (@x)") if not rs.eof then rsarray = rs.getrows() response.write(rsarray(0,0)) end if %> | |||
| Featured Websites | ||||
|
![]() |
| Tags: asp, procedure, records, stored, using |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Select records from result of drop down selection | C. David Rossen | Database | 3 | 05-31-2007 8:40 PM |
| HELP: SELECT only last last few records that were created within last 5 minutes | Neeper | Database | 0 | 05-31-2007 8:39 PM |
| Paradise Garage genre vinyl records for sale | galafuze | Ebay Technical Questions | 0 | 05-31-2007 1:06 AM |
| View photo stored into CD or DVD | Hervé | Computer Consoles | 2 | 05-30-2007 11:08 PM |
| Cheap Article Database (54,356 Records) + Free Package | Momo | Market Place | 3 | 07-10-2006 7:20 AM |
| Featured Websites | ||||
|