Re: Warning user before db update

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"AndyK" <AndyK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F2833A6E-D999-46DC-B0F3-17542CD9C198@xxxxxxxxxxxxxxxx
hi Mike

Thanks for responding. I should have made my question clearer, I
understand
how to check for EOF in a recordset.

What I needed to know was, I would like to warn the user without needing
to
do another round trip to the server, ie I would like to avoid:

- user clicks update
- server script obtains recordset and checks EOF
- server sends client another version of the same page with a warning
included

Thanks!

"Mike Brind" wrote:


The only way you are going to know is by doing a query on the database.
Either do it before so your data entry page has the info it needs to
validate (and that might be a lot of info), or after, once you know what
the user has entered. Personally I would do the latter

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters


.

Relevant Pages

  • Re: ADODB problems with multiple applications on the same web server
    ... latest 1.1 .net framework installed and this is still a problem. ... > I have Two ASP.Net applications running on a windows 2000 Server box. ... > the SQL Serverthe ADO RecordSet is not recordset BOF and EOF. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: TransferText from a table with a selection-parameter
    ... > temporary table where I store the recordset inside because there may be ... Each of your users can use separate temp tables in your SQL Server database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: VB-ADO-SQL Server : SQL Server performs logins after some queries
    ... The reason that I use Object types is that my code should work ... with a SQL Server 2K database (at a internet server) as well as MS Access ... recordset to a ADODB.recordset or a DAO recordset prior to creating the ...
    (microsoft.public.vb.database.ado)
  • Re: Was ist schneller und DB-verträglicher - FIND oder SELECT ?
    ... Dein Code ist insofern performant, ... Ich würde mir ALLE Daten in ein lokales RecordSet holen und dieses RecordSet ... Set cmd = New ADODB.Command ... ' Verbindung zum Server trennen... ...
    (microsoft.public.de.sqlserver)
  • Re: Which Approch is Better ???
    ... Severside cursor can hammer the server if you are performing many queries ... first recordset then return the items for the order in a second recordset. ... Round trips minimal. ... > I have tables like customer, supplier, item, salesman etc ...
    (microsoft.public.sqlserver.programming)