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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. Nlaivlys

    Trouble reading user input

    Thank you. I did try that (finally, after our server was restored). However, it still does not work. I get the following output: Enter number please ? FORTRAN Runtime Error: ? Attempt to read past end of file ? READ(UNIT=*,... It seems it just is not pausing to wait for user input. Any...
  2. Nlaivlys

    Retreive User Input

    So - there is no way to have a continuous prompt for user input and then a special terminating character within a script?
  3. Nlaivlys

    Retreive User Input

    Eventually, I would create a script to read values from a user into the postgresql db. In that script, it prompts the user to enter values needed. I just wanted to test this from the command line.
  4. Nlaivlys

    Retreive User Input

    Is there a way to retrieve user input for postgresql? I have done a search online and found that one can use: select * from mytable where user_id = [parameter "Enter text question here"] --or-- select * from mytable where user_id ~* '[parameter "Enter text question here"]' However, when I type...
  5. Nlaivlys

    Another Currval Problem

    Thank you - it worked by listing the values and leaving off the default incrementer.
  6. Nlaivlys

    Another Currval Problem

    The good news is, I have figured out what the problem was with the above query - I was using the wrong field as the auto increment. However, once one problem is solved, another pops up. I am looking into how to perform an insert into a table using a select statement. Here are the 3 queries I...
  7. Nlaivlys

    Another Currval Problem

    I'm not too sure how to use the sequence identifier. As for the date fields - I simply cut out some of the declarations in the overlay table. I cannot seem to get the auto increment field to work. Is there anything else I can do to fix that auto increment field?
  8. Nlaivlys

    Another Currval Problem

    I am fairly new to PostgreSQL. I am in the process of converting a MySQL script to postgresql. The mysql script includes a line that reads: INSERT INTO OVERLAY VALUES (NULL,LAST_INSERT_ID(),'Grey Standard','basemap',1,'png','y',-1,0,NOW(),NOW()), (NULL,LAST_INSERT_ID(),'Brown...

Part and Inventory Search

Back
Top