SQL and Variable Trouble

superDavecyber

Ok I am trying to store Sql Statements in a table... I have them listed as actions.. This way I can associate them with tasks and then I can manage them accordingly... The problem I am having is that I can not get my variables to fill into the sql statement...

So in example I have...

INSERT INTO tblComments ( CommentsComent, ProjectTasksId, EmployeeId ) SELECT '$comment' AS Expr3, $sid AS Expr2, $id AS Expr1;

as a saved sql statement in a table with the variables already set... Shouldn't they just fill in??? Any Ideas appreciated...

downsize

where are you selecting from? you are not specifying the table .. assuming you are using mysql :

mysql's insert/select syntax

superDavecyber

Unfortunatly I am not doubting My SQL statement...

It should just fill in Not??...

Here is a code snippet

        $comment=$_GET[comment];
        $tsk=$_GET[tsk];
        $ext=$_GET['ext'.$tsk];

            $sql="SELECT TblActions.ActionsSQL
                    FROM TblActions INNER JOIN TblLinkTasksActions ON TblActions.ActionsId = TblLinkTasksActions.ActionsId
                    WHERE (((TblLinkTasksActions.TasksId)=$tsk))
                    ORDER BY TblLinkTasksActions.LinkTasksActionsOrder;";
            $cur=odbc_exec($cnx,$sql);
            while(odbc_fetch_row($cur)){
                    $sql=odbc_result($cur,1);
                    print $sql;
                    odbc_exec($cnx,$sql);
            }

downsize

Originally posted by superDavecyber
Unfortunatly I am not doubting My SQL statement...

It should just fill in Not??...

Here is a code snippet

        $comment=$_GET[comment];
        $tsk=$_GET[tsk];
        $ext=$_GET['ext'.$tsk];

            $sql="SELECT TblActions.ActionsSQL
                    FROM TblActions INNER JOIN TblLinkTasksActions ON TblActions.ActionsId = TblLinkTasksActions.ActionsId
                    WHERE (((TblLinkTasksActions.TasksId)=$tsk))
                    ORDER BY TblLinkTasksActions.LinkTasksActionsOrder;";
            $cur=odbc_exec($cnx,$sql);
            while(odbc_fetch_row($cur)){
                    $sql=odbc_result($cur,1);
                    print $sql;
                    odbc_exec($cnx,$sql);
            }

[/B]

you are not doing anything there but selecting and outputing. I thought you were attempting to INSERT/SELECT?

superDavecyber

I am... In the Table Actions it has a field that holds Sql statements... I want to Execute all the statements associated with a certain task... The Problem is that I can't get the variables to pass into these Sql Statements...

I apologize for the confusion...

downsize

so you are saying that $tsk is empty or not being called?

superDavecyber

Ok The Colored Code as you said... Just selects things.. What it selects are stored queries...

One of with are the below listed.. What I want is for it to fill in the variables...

INSERT INTO tblComments ( CommentsComent, ProjectTasksId, EmployeeId ) SELECT '$comment' AS Expr3, $sid AS Expr2, $id AS Expr1;

$tsk is filling Fine.. I am cycling through fine... But the variables in selected SQL statements are not being filled... Any Idea as to why?

downsize

ok so not concerned with that SELECT statement not specifying a table to select from, you are saying that those variables are empty. and they are in the scope of the script where they should be filled since the script has those vars with values in them.

so in your while loop, if you were to echo out those vars:
$comment, $sid and $id
they have values?

superDavecyber

Thats The Problem!! They are full... It's just not moveing to the Sql Statement

I added this line

print "$comment - $tsk-$ext";

and it worked by returning

Testing - 2-Test!!

downsize

Originally posted by superDavecyber
Thats The Problem!! They are full... It's just not moveing to the Sql Statement

I added this line
print "$comment - $tsk-$ext";
and it worked by returning

Testing - 2-Test!! [/B]

Does your INSERT/SELECT statement work with straight SQL query via some SQL client?

superDavecyber

Yes it does... The PROBLEM is that the variables are not being put into the string... For what ever reason the values are not being put into the string... It is out puting just the variable names... Why is it doing this... All the SQL statements work...

Forgive me I am frustrated and I am missing something small I know it... But I assure you the SQL statements work...

If this does not work I am going to suck up my pride and just use ereg_replace. I will also change the variable names in the SQL statement to a HTML Like naming convention..