[AccessD] OT-AVAYA Auto-Attendent

That's needed if PayNo is a string.  If it is numeric, you don't want the single quotes in there.


On 30 Jun 2009 at 17:10, Max Wanadoo wrote:

> ..or..
> 
> strSQL = "SELECT PayNo " & _
> "FROM OurPersonnelTable " & 
> WHERE  PayNo = '" & $KEY & "';"
> 
> I have put two single quotes within the string to delimit $Key.  Either this
> or Stuart's posting should work
> 
> Max
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: 30 June 2009 09:20
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] OT-AVAYA Auto-Attendent
> 
> It;s looking for a PayNo which consists of the string "$Key"
> 
> build your string as:
> 
> strSQL = "SELECT PayNo " & _
> "FROM OurPersonnelTable " & 
> WHERE  PayNo = " & $KEY & ";"
> 
> -- 
> Stuart
> 
> On 30 Jun 2009 at 7:56, Paul Hartland wrote:
> 
> > To all,
> > 
> > Sorry for the OT, but didn't know where to post this.  We have AVAYA
> > telephone systems, and an auto-attendent manager (think it's called
> > VoiceMail Pro Client).  Where we can setup a number, then the user gets
> the
> > pre-recorded messages, with options etc, bit like most auto-mated call
> > centres.
> > 
> > I have a number, which when dialled will ask me for a payrol number, it
> then
> > repeats the payroll number.  I then open a coonection to our employees
> > database, and have a simple select query like below :
> > 
> > SELECT PayNo
> > FROM OurPersonnelTable
> > WHERE  (PayNo = "$KEY") ;
> > 
> > The payroll number I am entering is a dummy one, which has a record setup
> > for my details (PayNo 999999),  But the select for some reason is always
> > failing.
> > 
> > Anyone had any experience of this, and could point me to reference
> > sites/manuals etc
> > 
> > Thanks in advance for any help.
> > 
> > 
> > 
> > 
> > -- 
> > Paul Hartland
> > paul.hartland at googlemail.com
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com