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 strongm 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. jmccolley

    Carriage Return Problem In SQL

    I am using a text area dtc in Visual Interdev. When I type into the text area and press "Enter" the cursor moves to a new line but when the text is saved to the SQL 7 database the carriage return is not saved. When I read the data back in to print in a report the carriage returns are...
  2. jmccolley

    Carriage Return Problem In Text Area Control

    I am using a text area dtc. When I type into the text area and press "Enter" the cursor moves to a new line but when the text is saved to the SQL 7 database and the text the carriage return is not saved. When I read the data back in to print in a report the carriage returns are lost...
  3. jmccolley

    How to use setSQLText?

    When I response.write the values they are correct. If I then go to the command under global.asa and manually enter the values for each parameter the row is inserted correctly.
  4. jmccolley

    How to use setSQLText?

    Hi Merlin! Thanks for your help. I "almost" have it working! I have set up a DE command named InsertRevisionItems that uses the following sql: insert SubmittalPackagesItems (pkgcode, projidjobnumber, pkgitem, pkgdesc, pkgaction, pkgnotes, pkgclosed, pkggennotes) select pkgcode + 1...
  5. jmccolley

    How to use setSQLText?

    Sorry. I need to be more specific. When I try to use this string I get an error relating to syntax. Can anyone give me some tips on proper syntax and where to use the setSQLText command?
  6. jmccolley

    How to use setSQLText?

    The following sql query works to insert a row in my table when run from the Query Analyser. insert SubmittalPackagesItems (pkgcode, projidjobnumber, pkgitem, pkgdesc, pkgaction, pkgnotes, pkgclosed, pkggennotes) select pkgcode + 1, projidjobnumber, pkgitem, pkgdesc, pkgaction, pkgnotes...
  7. jmccolley

    Font selection for listbox in editable grid DTC

    Thanks Merlin. I will try your suggestions.
  8. jmccolley

    Font selection for listbox in editable grid DTC

    I have an editable grid that I can change the font face and size but it does not affect the font within the listboxes in the grid. Is there a way to change the font within the listboxes?
  9. jmccolley

    [color red]pageObject DTC not working

    Can I use a Page Object property to save a variable using client-side vbscript and then read the variable again on the page using server-side script? I have been able to set and get the variable from within client and server script itself just not between the two.
  10. jmccolley

    display message if form field matches existing record

    I have a form that needs to check to see if a number a user enters is already used in a recordset. I have a script to run through the records and compare the number for a match but how can I get a popup message to appear when the script I am using to check the number is a server side script...
  11. jmccolley

    RecordsetDTC AddRecord not working

    addImmediate worked! Thanks!
  12. jmccolley

    RecordsetDTC AddRecord not working

    I have tried your new improved fix but the record is still overwritten. I see this is an old post but any ideas on how to get this to work? I tried the setBookMark and getBookMark methods but I get an "undefined" error message. I assume it is because while adding a new record there...

Part and Inventory Search

Back
Top