Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome Programming
 PowerHome Messageboard : PowerHome Programming
Subject Topic: ph_sql bug? Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
kev21986
Senior Member
Senior Member
Avatar

Joined: April 04 2007
Location: United States
Online Status: Offline
Posts: 199
Posted: December 17 2009 at 16:05 | IP Logged Quote kev21986
I can run this SQL Query from the script editor in PH if I set
it to SQL and get results.

select * from macroheader;

But if I run this query in the Direct SQL page I get -1
results. Also if I run this formula in the script editor I don't
get results.

ph_sql(2,"select * from macroheader;")

Am I doing something wrong?

__________________
Kevin Smith
@respectTheCode
Back to Top View kev21986's Profile Search for other posts by kev21986 Visit kev21986's Homepage
 
kev21986
Senior Member
Senior Member
Avatar

Joined: April 04 2007
Location: United States
Online Status: Offline
Posts: 199
Posted: December 17 2009 at 16:37 | IP Logged Quote kev21986
Found the problem. The semi colon at the end of the sql
statement needs to be removed. This works.

ph_sql(0,"SELECT ID FROM macroheader")

__________________
Kevin Smith
@respectTheCode
Back to Top View kev21986's Profile Search for other posts by kev21986 Visit kev21986's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum