SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Apr 2002
    Posts
    136
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How do you query from a text .sql file?

    I want to make a distributed application and have it set up it's database by doing a query from a file attachment so the installation script doesn't need to change so often.

    Does anyone know how I can accomplish this? I know how to make file attachment forms and access the variables but I don't know how to successfully query the contents of a text .sql file.

  2. #2
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    load the contents of the file into a string variable and then execute that variable as you would any other string variable containing a sql command.
    -- JIM BOLLA
    Wanna play Halo 2? My XBOX Live gamertag: crowdozer


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
  •