Post reply

sql query to be accessed online

  • April 1, 2013 at 2:41 pm

    #394503

    Hi

    I just want to figure how to have a sql query that I generated in excel form and I want to put it online and I want it to update it self. is that possible?

    Thank you

  • April 1, 2013 at 2:46 pm

    #1602603

    I'm not sure I even understand the question.

  • April 1, 2013 at 2:54 pm

    #1602606

    First Thanks for your reply.

    I have a query and I want someone else in another country to be able to see that query so I want to put it online.

    Thanks

  • April 1, 2013 at 3:04 pm

    #1602611

    way too many assumptions and alternate technologies to even begin to offer much more than the basics.

    1. you would need a web server, that also has access to where ever the data is stored. do you have that?

    2. you would need a developer to write a web page so that people could actually be presented with some sort of page so they know what is going on. Do you have a developer?

    3. That developer would need the specifications of the project.

    Examples: WHO can go to/see the form? the public? only certain clients i.e. require a login)

    What inputs are required from the end user?

    what is the expected output (you said excel)

    in reality, it's typical to present the data as a web page, and provide an optional download as a pdf or csv or xls file.

    The web page can then be coded to take into consideration the security, presentation and export of the desired data.

    so you need a lot of background capabilities for this question to be answered with any degree of detail.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 1, 2013 at 3:04 pm

    #1602610

    Do you want the query to be online? or the output?

    Can you be more explicit? We can't see what you see, we don't know what you have.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • April 1, 2013 at 3:08 pm

    #1602613

    Hi,

    I want to output to be online. I normally run it on an excel spreadsheet.

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply