Search results for query: *

Chris, This is an internal app for a pos system. its all self contained. And they only use IE for the pos system. That what the forms within the system were designed around. I know, alot of common security is soooo breached, and if I werent learning as I created this I definately would have...

It was tried with and without the parenthesis. No worky But I did find a way to do it which took more programming knowledge than I started with. For some reason the sendkey commands didnt like pasting to itself so I set up an array and an outside file to save the data then read it back in. I...

Well I finally got it working. Main form is an HTA and to grab info from SQL it call an exe. Had to convert my vbs to exe to get it to work. Seems to run pretty good. Bosses like it and the client likes it. Thank for the guidance

Nothing like learning on the fly. I am starting to get the code cleaned up in both files. I really am sorry for any confusion about what I was doing to get this to work. Sooooo not a programmer.

Sorry, I thought I had explained that I was using both. Depending one how quick I could get ones way or the other programmed. Here is my vbs file that gets called. It works fine when run on its own to read and create input and results files. The sql doesnt seem to execute when run through the...

Well, almost there. I have gotten this dang thing to create an input file for the item number using javascript, then in vbscript I am able to read that file and display the returned data back to the html form. Only hiccup it creating he correct results file. I run the vbscript on its own and...

ok, how about this then... I modified my script to read from for input and create an output file for results. Is there script that will work in the html form to create the input file(only needs to contain the txtItem field) and then read the results file to input into my description, average...

Ugh the horror story... I work on POS systems and a client is asking for a margin calc so his sales people can find current margin and determine new prices and margins within limits. So my first go'round was easy. I wrote a quick vbsscript to pull the data from sql but they wanted it to...

Ok that is why the box doesn't popup. But that was only for testing anyways. Is that also why it wont read into SQL and fill the variables? Would doing something like writing to a text file and read it into vbscript work better then read the results into another text file to go to html through...

Ugh... What a pain. My test code for funtion work if run as a vbs file: on error resume next dim dbconnection, sqlrs, itemno, sqlrs2 const CONNECT_STRING = "provider=SQLOLEDB.1;Presist Security info=True;User ID=sa;Initial Catalog=DEMODATA;Data Source=SERVER;password=PASSWORD" Set WshShell...

That was how my vbs code was written for another project that works fine. This exploration into html and java with vbs has been an experience

That was the name of the view it is pulling data from since it comes from 3 different tables

That has been the biggest help so far. It is the select statement. Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Thank goodness. A new place to look

Well, I am still trying different thing I find. No luck. All this needs to do is connect this stand alone form to the clients sql database when the button is clicked to pull the item and display the info. if there is a better way please advise. I am not a programmer and the parts that work are...

That why they are inside the quotes. SQL needs them

The highlighted. For somereason I cannot get the on_click to run to the vbscript Just using the vbscript grab database info to display it in the html window

I guess someone thinks this may belong here versus HTML forums. I highlight the section I am having trouble with I have included my html code for many other eyes to help me figure this out. Javascript works. One side by on_click and other side by on_change. Issue is when calling my vbscript...

I have included my html code for many other eyes to help me figure this out. Javascript works. One side by on_click and other side by on_change. Issue is when calling my vbscript. This is a modified version of a working script that just displayed some data a client wanted to see, but now they...

What am I doing wrong? I can copy and paste my relevant data into notepad, word, and even point of sale software but I cannot seem to get my vbs script to paste into it's own input box. I am very confuzzled. First part copies item number to be pasted into script: WshShell.AppActivate...

Nevermind. Forgot to change database name to table name. What a Homer!!! DOH!!!!