Search found 7 matches

by ihechi
Thu Apr 04, 2013 12:48 pm
Forum: VBScript
Topic: How can I add date range to code below?
Replies: 16
Views: 11499

Re: How can I add date range to code below?

Hi, Ok, let me try to explain agaiin. In my original post of a few days ago, I stated that we have an app with a search functionality below that works great. SQL_query = "SELECT typeofdocument, btyp, bkno, disp, dispdt, PGNO FROM myTable NAME '" & Replace(txtsrch,"'","''") & "' ORDER BY NAME " Now, ...
by ihechi
Thu Apr 04, 2013 11:00 am
Forum: VBScript
Topic: How can I add date range to code below?
Replies: 16
Views: 11499

Re: How can I add date range to code below?

I have this radio button called ANDOR where the values can either be AND or OR. <input name="ANDOR" id="ANDOR" type=radio checked value="AND"> Match all <input name="ANDOR" id="ANDOR" type=radio value="OR"> Match any I want to use the ANDOR in my query where clause. Example: ' and now build up the W...
by ihechi
Thu Apr 04, 2013 9:22 am
Forum: VBScript
Topic: How can I add date range to code below?
Replies: 16
Views: 11499

Re: How can I add date range to code below?

Ok, I am almost done with this but I am stuck on one issue. How do I manage radio buttons? I have the following radio buttons I am trying to use as WHERE clause. <input name="ANDOR" id="ANDOR" type=radio checked value="AND"> Match all <input name="ANDOR" id="ANDOR" type=radio value="OR"> Match any I...
by ihechi
Mon Apr 01, 2013 1:35 pm
Forum: VBScript
Topic: How can I add date range to code below?
Replies: 16
Views: 11499

Re: How can I add date range to code below?

Ok, thanks a lot.
by ihechi
Mon Apr 01, 2013 12:40 pm
Forum: VBScript
Topic: How can I add date range to code below?
Replies: 16
Views: 11499

Re: How can I add date range to code below?

Ok, great.

I do have one question right off the back.

In asp, we use something like this to get form value:

andor = Request.Form("ANDOR")

I am using the following as an equivalence in .hta:

andor = ANDOR.value

Is that correct?
by ihechi
Mon Apr 01, 2013 12:17 pm
Forum: VBScript
Topic: How can I add date range to code below?
Replies: 16
Views: 11499

Re: How can I add date range to code below?

Hi JVierra, Thank you very much for your response. I will get started as you instructed and post back with specific questions. I have actually done this numerous times. My doubt here is because it involves .hta. BTW: I have read a ton of solutions you have provided to lots of people. Thanks a lot fo...
by ihechi
Mon Apr 01, 2013 11:02 am
Forum: VBScript
Topic: How can I add date range to code below?
Replies: 16
Views: 11499

How can I add date range to code below?

Greetings Experts, Currently, we have vbscript and .hta app with SQL Server as backend database. Our users can search the database with firstname, or lastname, or both. This works very well. Here is code snip: 'Take care of sql injection tactics SQL_query = "SELECT TOP 100 Name, Rel, Estno, dtfild, ...