Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jerijeri
  • Content: Threads
  • Order by date
  1. jerijeri

    How to Convert Static Text to Hyperlink

    I'd link to have a hyperlink on one of my dialog forms. I can hyperlink to the site using a button, but would like to have the domain url appear as a clickable link. Is it possible to do this in Visual C++ 6.0? If so, are there any code samples available? Thanks, Jer
  2. jerijeri

    Create Invisible Gif automatically

    I need to have PHP generate an invisible gif and output it. I know I can have my program read an invisible gif and output it. That's normally what I do. For this application it's not suitable. In Perl I did this by: print "Content-type: image/gif\n\n", pack "H*&quot...
  3. jerijeri

    How to Create directory from text field

    I need to create a large number (2500+) of directories on my computer. I have a text field that will consist of rows of data like: atlanta los_angeles detroit new_york I'm reading these in from a text file. I'm trying to figure out the code that will read each line in the text field and...
  4. jerijeri

    Program similar to PGP

    I'd like to be able to store some information in a table and have it safe from prying eyes. I do need to be able to decrypt it. Currently we're using a RC4 routine to save the information. If someone looks at the data, it won't do them any good - unless they find the key that's stored on the...
  5. jerijeri

    Can one copy first letter of field to another field

    HI, I'm wondering if there's a MySQL command/function to copy the first letter of one field to another field. Thanks, Jer
  6. jerijeri

    Finding number of passwords left

    HI, We have a table that looks like the following: id,username,password,area,order_id 1,joe,88,5,100 2,joex,99,5,102 3,joey,77,5,NONE 4,jane,66,4,101 5,janey,22,4,NONE What we want to do is have the results displayed as Area, Available, Issued 5 1 2 4 1 1...
  7. jerijeri

    Problem with Autoincrement, and starting autoindex value of 0

    Hi, I have certain tables where I'd like the record id to autoincrement and start at 0. 0 would recommend someone who doesn't have access 1 and above have different access privileges. There are new levels added, hence the desire to use Auto-increment. The problem comes when I use SQL dumps to...
  8. jerijeri

    Regular Expression problem

    I have a csv file that has multiple dates in it. they are in the format 1/17/2003 I want to convert to 2003-01-17 I've tried the following expressions: match {.*}\/{.*}\/{.\d.\d.\d.\d}, replace with \3-\2-\1, (this doesn't handle converting 1 to 01) but that's not the biggest problem...
  9. jerijeri

    Regular Expression matching variable name

    Help, I'd like to replace all merge fields with a corresponding variable. Currently we have one line s/\\!(\$[\w\[\]\{\}\'\"]*)\\/$1/eeg; handling all the replacements. example we have \!$FORM{Text1} to \!$FORM{Text20} and $Text1 to $Text20 are replaced. We'd like to change the...
  10. jerijeri

    Update not working when comparing fields in two tables

    Hi, I have a master customer table. I also have a temporary table for customers who meet a set of criteria each month. Our plan was to upload the acct numbers into the temporary table and then modify the master table if the customer's ID is in the temporary table. Here's the query. UPDATE...
  11. jerijeri

    Problem importing text file into database

    Hi, I'm trying to set up a program to read a text file and import into MySQL. There are three pipe delimited fields. This is the error message I get: Database error: Invalid SQL: LOAD DATA LOCAL INFILE '/home/virtual/site2/fst/var/www/html/temp/clients.txt' INTO TABLE customer FIELDS...
  12. jerijeri

    Getting Sum of People Belonging to Record in Same Table

    Hi, I have a table structured (simplified for example) like this: id: Name : Trainer_id 1:John Doe: 2:Jane Doe: 3:Linus T: 4:Charlie B:1 5:Lucy L:1 6:Bob R:3 7:Jimmy B: 8:Suzie Q:1 I want to create a Query that will output the following: Salesperson ID : Name : # of Trainees 1...
  13. jerijeri

    skipping blank lines in file

    HI, I have a large number of files in a directory. I need to read the names of each file and then print a listing. For example /files/AKanchorage /files/TXDallas. I want to read each file and then print data like this: anchorage:Line 1 anchorage:Line 2 Dallas:Line 1 Dallas:Line 2 There are...
  14. jerijeri

    Automatic POSTing of Data

    Hi, I have a program called questions.php. It displays 5 text fields. The user then fills in the fields and the information is posted back to questions.php. At this time the information is stored in a MySQL database and the information entered is sent by means of a querystring to a different...

Part and Inventory Search

Back
Top