Printable View
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.Quote:
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?
HTML in itself is static and you will be able to generate dynamic content which you seem to be trying to do.
1. The question is somewhat redundant, since (as xplained) HTML is static. You cannot "send data to anhtml doc to another html doc" :confused: You must use server side scripting.Quote:
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?
2. More importantly, why, and what are you trying to accomplish?
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:)
Quote:
Originally posted by alperaydin
Is that just a dream?
YYYYYYYYYyyyyyyyyyyyyyyyyyyyyyyeeeeeeppp!!!
Try looking into examples using javascript.
Since when has client side scripting worked with databases?Quote:
Originally posted by johnweidauer
Try looking into examples using javascript.
:afrog:
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.
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:
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.
Even PHP and ChiliSoft still require a webserver..... Be it IIS or Apache or NetBSD, you still need a webserver to run serverside programming.Quote:
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.
TG
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.
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. :D
Maybe I don't get it, but to run PHP, one would still need IIS....Quote:
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.
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
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.
;)
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 :) ?
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.
So use XML.
I neglected XML, probably cause my office is cold and my fingers hurt after a lot of typing :rolleyes:
however, that is a good idea as well
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.
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.