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...
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...
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.
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...
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?
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...
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?
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.
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...
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...
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.