MSSQL - ASP
by Klaas De Waele <klaas(at)gracegraphics.be>
|
| Date: |
Fri, 23 Nov 2001 15:18:59 +0100 |
| To: |
"'hwg-techniques(at)mail.hwg.org'" <hwg-techniques(at)mail.hwg.org> |
| |
todo: View
Thread,
Original
|
|
Hi there,
might remember some time ago I was wondering about converting Access to SQL
and asking some things about Apache and PHP and PySQL.
Must say I was succesful at getting round to PHP, MySQL and Apache, AND
today just installed SQL server 7.0 and converted the complete site to SQL
server. Nice, smooth and well... did notice a small improvement in
performance. It all just worked out of the box, apart from these things:
Apache webserver: .htaccess files don't work on the Windows PC I temporarily
used for MySQL and stuff
SQL Server: approaching text/ntext fields from ASP returns empty strings.
Can be solved by doing a select x,x,x,x, instead of select *, putting
text/ntext fields last and treating them first. Problem is I use lots of
loops and extra tables to have generic forms, so... for now I just converted
them to long (too long, I admit) varchar columns. Any advice?
Still have to learn a lot of PHP thought, but I can convert my Easy Content
Management modules already and will try an uploading script in cgi later
this night. (If anyone knows something lying around somewhere, do let me
know).
Thanks for all those who helped me. I'm going to have to get rid of that
terrible headache now. ;)
- Kayjey -
www.fiatcoupe.net
HWG hwg-techniques mailing list archives,
maintained by Webmasters @ IWA
This page is part of a preserved archive of archives.hwg.org. The site is no longer active and its content is not maintained. For enquiries about this archive, write to archive(at)iwanet.org.