Queries

Elon Richards ( (no email) )
Tue, 27 Jan 1998 12:13:23 -0500

Hi Guys

Is there any way of allowing users to change their login passwords via
the internet in Emerald?

While using the Emerald client, and editing a user in the database, we
clicked on the Time On tab. We then clicked the Update command button
which generated a SQL Query error. Using the SQL trace, we realised that

whatever values was typed into the Start Time and Stop Time fields were
being treated as character in the query when compared to the CallDate
field. What little knowledge I have of SQL queries says that this will
never work even if a valid date string is entered in these fields. Has
anyone reported this problem and is there a cure to it??

--||||||||||||||||||||||||||||||||||||||||||

/// /@ @\ ( ) ---o000----( )----000o-------

Elon Alonza RichardsBarbados External TelecommunicationsInternet Engineer

ear@caribsurf.com246 431 6130(w)pager: 246 429 7243 ,ID: 6130