SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
Thread: Database Abstraction with ASP
-
Nov 11, 2001, 15:53 #1
- Join Date
- Jul 2000
- Location
- Here
- Posts
- 1,010
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Database Abstraction with ASP
It was recently suggested to me by shane that I would need to 'abstract' my database functions from my code.
I have been reading into this and I still cannot find solutions to some of my problems here. First of all, how can I perform SELECTS using functions? It is pretty simple to open a database connection and execute SQL statements, but for retrieving values and rows, I am stuck. Can someone with experience in db abstraction and ASP help me out? Does anyone have a sample abstraction file that I could use (with my modifications)?
Thanks
-
Nov 11, 2001, 20:27 #2
- Join Date
- Nov 2001
- Location
- London, UK
- Posts
- 502
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
No Offence but from your website:
infinetSoftware can create a variety of business applications including Access Database software, Microsoft Office integration, Windows NT/2000 integration, and more. To learn how infinetSoftware can help your business, email info@infinetsoftware.com for more information.
What you're asking require some what long explanations... and I dont think I'd have space to explain everything here about db abstraction and ASP, and how to use SQL Select statements.
But since I am being generous and feel bad not halping you... I've got several URLs for you.
http://www.asp101.com/articles/wrox/3382/33820605.asp
http://www.asp101.com/ado/index.asp
http://www.asp101.com/articles/wrox/asp30/26100903.asp
http://www.asp101.com/articles/wrox/asp30/contents.asp
I hope this helps you out.
by the way... do forgive me.. if I am being unfair critising you or parhaps your company.
Please reply to me if am incorrect in my critisim, only you can help me to realise the mistakes I am making by knowing little about you and your company. I am sure the sitepoint mentor will agree with me. well at least I hope so.
-
Nov 11, 2001, 20:30 #3
- Join Date
- Jul 2000
- Location
- Here
- Posts
- 1,010
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I know what you mean, but I DO know what I am doing. Everyone runs into new problems and new ideas. I have never personally had a need for database abstraction before. In addition, before your post I had already found a solution. And finally, the URLs you provided had content that I already know. Sorry to argue back with you, but I do know what I am doing.
Last edited by wdmny; Nov 11, 2001 at 20:51.
-
Nov 13, 2001, 00:49 #4
I think it is quite uncommon to have a generic database abstraction layer. In my experience, almost all SQL statements reside in either custom COM objects or stored procedures. Both of these provide more security and performance than creating generic ASP functions to access your database.
http://www.echo-consulting.net - Sound Solutions for Online Inspriations.
-
Nov 13, 2001, 16:54 #5
- Join Date
- Jul 2000
- Location
- Here
- Posts
- 1,010
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
That is true, but not always possible. In this case, I am going for customizable, simple, and multidatabase use, and therefore, stored procedures and COMponents aren't preferred.
Bookmarks