SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard wdmny's Avatar
    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

  2. #2
    SitePoint Evangelist azizur_rahman's Avatar
    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.
    It seems to me that you already provide business Access Database and integration. Its really shame that software company like your's or the one you're working for provide the service and not know how to do this. It really breaks my heart to see this post.

    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.

  3. #3
    SitePoint Wizard wdmny's Avatar
    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.

  4. #4
    grasshoppa Snowbird122's Avatar
    Join Date
    Apr 2001
    Location
    Austin
    Posts
    353
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  5. #5
    SitePoint Wizard wdmny's Avatar
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •