I'm building a web-based database query tool. The results are displayed in a gridview on the page. I'm trying to offer the users the ability to print *only* the gridview in plain formatting. What I was advised by senior programmers at work to do is to load the gridview results into the...
basically, the user is presented with a GUI (perl/tk) each entry box widget is assigned to a variable in which whatever text is typed into the box is assigned to a specific variable just for that box. The SQL query needs to be built off of that each timet the user does a query with the GUI. I...
Anyone know of any good guides on Perl and Dynamic SQL queries? I'm writing a huge application and I've decided that Dynamic is the best way to go. If anyone knows of any or could offer any help, please let me know.
Ok, I have run some more tests...I think my problem lies in my query.
If I understand the above, -textvariable is assigning the text typed into the entry box to the variable $Location. If this is true, then from there, I don't know how to build the SQL Query correctly.
Right now, my query is...
I have built a GUI in Tk that is supposed to take user input and search an MS SQL database. I am about 3/4 complete, however, I cannot seem to get the script to search for what the user wants. I need a way to actually assign what is entered into the Entry box (or multiple Entry boxes) to a...
At work I am expected to create GUIs with wxPerl, however, I am not allowed by the administrators to install anything on the C: drive, only the U: drive. It seems though that wxPerl only wants to install to the C: drive and the install fails every time with a Permission Denied, even using the...
Ok, so this is my "semi-final" script. It does what I need it to which is assign the whole file to @data, close the output file, reopens it and runs the script right under it. I know it may be a little inefficient but it works. If anyone has any ideas on how to make it look/work a little...
its a 3.5Mb file.
I was thinking that if I could just turn the whole file into one long string that it could work that way...unfortunately, I'm learning as I go and don't know how to do that exactly. Hope I'm not being too much of a pest here.
Kevin,
I tried the word boundary and non-word boundary. It ended up shortening the results that I have somehow.
The pattern that I have right now works, it just doesn't include newline breaks and I don't know how to include newlines in a pattern so that it will go to the next line and read up...
The below code searches for the word 'located' in a text file. When it finds the word, it looks for 1 to 10 words after it, extracts the string, and writes the string to a file. The problem I am having is that the current script stops looking for up to the 10th word when it reaches a line...
Steve,
I understand the rant. I hear ya and I will be sure to follow by it. Now...haha, I have another question.
This is the code that I have now thanks to Kirsle:
open(INFILE, "textfile.txt") or die "File not found.";
$doccount = 0;
$repcount = 0;
while (<INFILE>) {
if (/(\*\*\*...
Kirsle,
The code worked absolutely perfectly. Thanks for the help.
I do have one more question about the code though. I forgot to mention this. I've done this in Python, but can't seem to get it to work with the code you provided.
While the above code seperates each report and writes it to...
I didn't explain what I did...sorry about that.
this:
if(/(50.1\t+?1065\.1)|(51\.1\t+?14\.1)|(52\.1\t+?101\.1)|(53\.1\t+?100\.1)/m)
is just a regular expression that reads the file and if these numbers are found:
50.1 1065.1
51.1 14.1
52.1 101.1
53.1 100.1
then it prints them to a file...
I saved the text content you have above in a file called encino.txt (because I'm not sure of the name of the text file you want parsed.) I then named the output file to output.txt. Remember to replace encino.txt with whatever the filename is that you have.
This code is quick and dirty, but it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.