SQL in HTML without ASP

**alperaydin** · Dec 21st, 2003, 04:43 PM

hi,
i want to ask if it's possible to send data to an html doc to another html doc and execute an SQL query with the data received from the sender html page.

i made an ADO connection and executed a query in my html page. I must rebuid the query with the sent data from first page. But i dont want to use ASP. is there something like Request.Querystring in html?

**Danial** · Dec 21st, 2003, 06:48 PM

Originally posted by alperaydin
hi,
i want to ask if it's possible to send data to an html doc to another html doc and execute an SQL query with the data received from the sender html page.

i made an ADO connection and executed a query in my html page. I must rebuid the query with the sent data from first page. But i dont want to use ASP. is there something like Request.Querystring in html?

You cant do that just with HTML, you will need some sort of scripting language for database connectivity. E.g ASP, PHP and few others.

HTML in itself is static and you will be able to generate dynamic content which you seem to be trying to do.

**mendhak** · Dec 22nd, 2003, 10:22 AM

Originally posted by alperaydin
hi,
i want to ask if it's possible to send data to an html doc to another html doc and execute an SQL query with the data received from the sender html page.

i made an ADO connection and executed a query in my html page. I must rebuid the query with the sent data from first page. But i dont want to use ASP. is there something like Request.Querystring in html?

1. The question is somewhat redundant, since (as xplained) HTML is static. You cannot "send data to anhtml doc to another html doc"

You must use server side scripting.

2. More importantly, why, and what are you trying to accomplish?

**alperaydin** · Dec 22nd, 2003, 12:33 PM

thank you for your replies
i wanted to make an html page to serve a database table with some parameters defined by the client. And i didn't want to use ASP, in order not to install IIS or PWS. (finally i installed)
But i still wonder if i can do something like that:
putting some option objects on the page and binding a sub defined in <SCRIPT> to their onclick events. Each time an option is clicked, onclick event will call the CreateList sub. And in the sub the parameters of the query will be determined by the options.

Is that just a dream?
thanks all

**mendhak** · Dec 22nd, 2003, 01:46 PM

Originally posted by alperaydin

Is that just a dream?

YYYYYYYYYyyyyyyyyyyyyyyyyyyyyyyeeeeeeppp!!!

**johnweidauer** · Dec 22nd, 2003, 01:50 PM

Try looking into examples using javascript.

**mendhak** · Dec 22nd, 2003, 03:09 PM

Originally posted by johnweidauer
Try looking into examples using javascript.

Since when has client side scripting worked with databases?

**johnweidauer** · Dec 22nd, 2003, 03:13 PM

Well, I have written stuff using Javascript that allowed you to instantiate ActiveX objects that existed on the client machine. Not the ADO Control, but other things, thought maybe you could do this as well. If its SQL or something, if the server allowed anyone to connect to the db, then i thought it might be a realistic idea, but maybe not.

**mendhak** · Dec 22nd, 2003, 03:35 PM

Aah, ActiveX. But that'd just add as an extra overhead headache for him/her, wouldn't it? I'm sure there's an easier way to accomplish whatever he/she's trying to do.

Besides, I personally am paranoid about running ActiveX controls on my machine nowadays. :paranoid:

**johnweidauer** · Dec 22nd, 2003, 03:38 PM

Overhead yes, threatening, no.

If you think of it, you would be using an Active X created By Micro$oft that is already running in multiple locations on your machine. It would make the connection to the DB slow.

If HTML is the only option, meaning unable to run the web server on IIS, then maybe go with some free stuff like PHP, or ChiliSoft or something. Dunno, just a thought.

**techgnome** · Dec 22nd, 2003, 03:45 PM

Originally posted by johnweidauer
If HTML is the only option, meaning unable to run the web server on IIS, then maybe go with some free stuff like PHP, or ChiliSoft or something. Dunno, just a thought.

Even PHP and ChiliSoft still require a webserver..... Be it IIS or Apache or NetBSD, you still need a webserver to run serverside programming.

TG

**johnweidauer** · Dec 22nd, 2003, 03:49 PM

true, figuring his requirement for DB Connectivity via HTML, i thought maybe IIS was not an option, thus ChiliSoft or PHP, free.

alperaydin, what webserver are you running, also, Request.QueryString, works in ASP only.

**mendhak** · Dec 22nd, 2003, 03:59 PM

Apparently, he does have PWS or IIS, but just doesn't want to use it. That's the part that confuses me... but hey, he must be human.

**techgnome** · Dec 22nd, 2003, 04:17 PM

Originally posted by johnweidauer
true, figuring his requirement for DB Connectivity via HTML, i thought maybe IIS was not an option, thus ChiliSoft or PHP, free.

alperaydin, what webserver are you running, also, Request.QueryString, works in ASP only.

Maybe I don't get it, but to run PHP, one would still need IIS....
Unless you run Apache.... or NetBSD.... point being that it requires somekind of websrver... IIS or otherwise. I get the feeling that this is being developed for something internal, and doens't have the cababilities to set up IIS.
Personally, ActiveX is a bad way to go... 1) Not all browsers support it. 2) There is some current litigation going on regarding the ability to run objects within the browser.

TG

**johnweidauer** · Dec 22nd, 2003, 05:17 PM

I have thrown out a couple of ideas. Trying to offer ideas since all of the information needed to provide a solution has not been given is all.

**Danial** · Dec 22nd, 2003, 06:31 PM

Mandhak i dont think its paranoia, ActiveX control which running of a html page is just not safe. It has as much the same power as an .exe. Even client side VBScript is pretty powerful and i have seen people using that to read/modify registry settings though i think that exploits has been fixed. Even IE wanrns you before downloading ActiveX,that indicates something !

But for say a intranet application it would be useful to use ActiveX to make some parts of an application accessible via web browser.

johnweidauer: what the writing in the tea shirt ! Is it the blue screen of death

?

**johnweidauer** · Dec 22nd, 2003, 06:45 PM

Ok, so this has turned into a discussion.

1) I would not recommend running ActiveX objects in web environments unless you are running a service that needs to be powered by something a little more robust than ASP, or you are on an Intranet and the above applies.

2) Instantiating the ADODB ActiveX from javascript doesnt install any software, it calls an existing/registered DLL on Windows machines - client side, given it exists.

3) A web server is needed, which one being used in this discussion is unknown. For a better answer, please provide the web server being used.

4) However, if you would like to show database tables, you can use Front Page Server Extensions, if supported by the web server, and create HTML pages that connect to the data using the Front Page "BOTS". This would require #3 to be answered.

**nkad** · Dec 22nd, 2003, 06:49 PM

So use XML.

**johnweidauer** · Dec 22nd, 2003, 06:51 PM

I neglected XML, probably cause my office is cold and my fingers hurt after a lot of typing

however, that is a good idea as well

**Travis G** · Dec 23rd, 2003, 08:38 AM

I wanted to jump up and down and yell and remind you that JScript is not JavaScript, and that JavaScript can't call ActiveX objects. JScript can. JScript is proprietary and closed, as a result, it is supported by a single browser, and that browser has the worst support for things like CSS.

**johnweidauer** · Dec 23rd, 2003, 11:35 AM

my mistake...it has been a while.

I had used Javascript to control ActiveX object on the web page, not instantiate the object.

sorry for the confusion.

Thread: SQL in HTML without ASP

Thread Tools

Display

SQL in HTML without ASP

Re: SQL in HTML without ASP

Re: SQL in HTML without ASP

thanks all

Re: thanks all

Javascript ????

Re: Javascript ????

Client Side / DB

ActiveX Javascript

Re: ActiveX Javascript

webserver

Web Server?

Re: ActiveX Javascript

wow...

XML True dat

JScript != JavaScript

your right

Posting Permissions