Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Search Results Problem

Posted on 2004-09-23
1
Medium Priority
?
183 Views
Last Modified: 2010-04-25
I'm using DWMX / PHAKT / PHP / MySql.  I've set up a search query as shown below. When I test the 'DateListed' field with a real date, such as 2004-09-10, in the recordset Server Behavior window, it works fine.  But, when I run the same DateListed query from the actual search page, it produces no records on the result page.  All the other variables work fine on the results page.  

SELECT* FROM projects WHERE county LIKE '%varcounty%' AND license LIKE
'%varlicense%' AND DateListed >= 'varlisted'

Variables:
Name         Default        Run-time Value
varcounty    %                $HTTP_GET_VARS['county']
varlicense    %                $HTTP_GET_VARS['license']
varlisted      %                $HTTP_GET_VARS[listed]

What am I doing wrong?  Any help would be greatly appreciated.


Richard T

0
Comment
Question by:grnt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 10

Accepted Solution

by:
rockmansattic earned 375 total points
ID: 12132528
This is not a Dreamweaver question, you would yeild better results in sql or Mysql section of EE.

BUT,
possibly change $HTTP_GET_VARS[listed] to $HTTP_GET_VARS['listed']

but the real problem looks like it lies in the data stored in that variable.  I would bet that it is not in the correct format YYYY-MM-DD as your test is in.

Rockman
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question