Hi:
I had no problems with SQL queries in the old Links, but seem to be banging my head on the new SQL Monitor.
Background: Prviously, when I had a contributor... lets say Ken Layton.... I would credit himn with a "Contributed By" credit which I put in the feild "Production_Notes" Because we now have "Linkowner" I was going to switch this "credit" over to this field, and print it on a detailed page with an <%if Linkowner%> statement. Easy!
OK, so I am in SQL Monitor, trying to run this commant to find all the cartoons Ken gave me:
and I get no results. I have tried "%" in stead of "*", "Like" instead of "=", nothing. Yet, when I search from the Admin Interface, I DO get results of a Ken Layton search!
I am stymied... I am pretty sure my stntax is correct, why do I not get results?
dave
I had no problems with SQL queries in the old Links, but seem to be banging my head on the new SQL Monitor.
Background: Prviously, when I had a contributor... lets say Ken Layton.... I would credit himn with a "Contributed By" credit which I put in the feild "Production_Notes" Because we now have "Linkowner" I was going to switch this "credit" over to this field, and print it on a detailed page with an <%if Linkowner%> statement. Easy!
OK, so I am in SQL Monitor, trying to run this commant to find all the cartoons Ken gave me:
and I get no results. I have tried "%" in stead of "*", "Like" instead of "=", nothing. Yet, when I search from the Admin Interface, I DO get results of a Ken Layton search!
I am stymied... I am pretty sure my stntax is correct, why do I not get results?
dave