2. PHPRunner General questions
  3. [SOLVED] Does DBLookup alter the SQL text?
This topic is locked
[SOLVED]

Does DBLookup alter the SQL text?

 		7/21/2022 2:14:10 AM
PHPRunner General questions
A
 asawyer13 authorDevClub member

I have this statement for a DBLookup

DB::DBLookup('Select EventText from EventNotice WHERE GETDATE() BETWEEN NoticeDateFrom AND NoticeDateTo')

I am using SQL Server so Getdate() is valid and would return today's date/time.

NoticeDateFrom and NoticeDateTo are both Date fields in SQL Server.

If I run the sql statement in SQL Server Management Studio I get the one value back I'm expecting.

Any idea what I'm doing wrong?

Alan
A
 		asawyer13 authorDevClub member 7/21/2022

Someday I'll learn. Just my error. Pointing to the wrong database, so the data wasn't what I was expecting.

Sorry for the confusion.

Alan