Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
A donation makes a contribution towards the costs, the time and effort that's going in this site and building.
Thank You! Steffen
Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
| |
|
 Topic: dbd_modules-1.0.3a for 2.2.9 available |
|
| Author |
|
Steffen
Moderator
Joined: 15 Oct 2005
Posts: 3092
Location: Hilversum, NL, EU
|
 Posted: Fri 13 Jun '08 20:20 Post subject: dbd_modules-1.0.3a for 2.2.9 available |
 |
|
Tom made his modules available for 2.2.9 on the download page.
Because the APR has changed from 1.2 to 1.3, a new odbc driver is needed. This required a new download for dbd-modules.
Good news - the old (APR 1.2) driver was named apr_dbd_odbc.dll but the new (APR 1.3) driver must be named apr_dbd_odbc-1.dll. Both old and new drivers can be included in the .zip file so it will be OK with either 2.2.8 or 2.2.9.
For more info on the dbd modules see www.apachelounge.com/viewtopic.php?p=9970
Steffen |
|
| Back to top |
|
tdonovan
Moderator
Joined: 17 Dec 2005
Posts: 611
Location: Milford, MA, USA
|
| Posted: Sat 14 Jun '08 17:17 Post subject: |
|
|
If you use the odbc driver, note that Apache 2.2.9 (actually APR 1.3) requires a change to your SQL statements.
The parameter markers which were previously ? should now be %s. For example: | Code: | | AuthDBDUserPWQuery "SELECT Password from Users WHERE User_ID = %s" |
APR 1.3 added the ability to handle binary data, as well as text strings. Nothing in Apache uses this yet, so only string values (%s) are used with existing Apache modules.
FYI some of the other new parameter markers are:%d - integer, %ld - long integer, %f - floating point, %d - double-precision floating point, %pDd - date, %pDi - time See \include\apr_dbd.h for the complete list.
-tom- |
|
| Back to top |
|
|
|
|
|
|
