Hi,
we are not really trained in analyzing Oracle-logs. I've been using Mysql
and Mssql for years, but the migration was more difficult, than I thought.
In $ORACLE_HOME/admin/%database% I have Gigabytes of logs, so do not know,
where to start...
du -sch *
1.5Gbdump
166Mcdump
28K create
I think everyone knows that $sql is a statement. But what people are
asking is: what is that statement?! Because if there are "incorrect"
characters or 's in that statement, then that can break your
code/statement.
~Philip
On Sep 9, 2004, at 5:49 PM, Stuart Felenstein wrote:
Just getting back t
As I said this is a code generator (dbqwiksite). So,
describing the process for creating the code is
different. The $sql is fine, as far as typos or
incorrect characterrs. I've gone through those
statement very carefully.
I've also tried to run a debug with no luck.
But I do know that there is so
did you make the change to the code I suggested? What does MySQL say the error
is?
-Micah
On Friday 10 September 2004 07:49 am, Stuart Felenstein wrote:
> As I said this is a code generator (dbqwiksite). So,
> describing the process for creating the code is
> different. The $sql is fine, as
I'm trying to run an INSERT query on my mysql database and it isnt working.
Here is the query:
$updatequery = "UPDATE `users`
SET
('company','fname','lname','address1','address2','city','state','zip','phone','extension','fax','email')
=
I had not, my apologies. I think your post slipped
by. Anyway, yes I have now inserted mysql_error() and
got my return. Though I'm not entirely sure how to
fix it.
Here is the error.
You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the
rig
If you look at the query, there's no column name between 'WHERE' and 'LIKE'
which is a syntax error. That's the problem.
Looks like your sql generator has some issues, or you didn't specify the WHERE
column properly. I'm not familiar with the system you're using, but keep in
mind, that mysql_
--- Aaron Todd <[EMAIL PROTECTED]> wrote:
> I'm trying to run an INSERT query on my mysql database and it isnt
> working.
>
> Here is the query:
> $updatequery = "UPDATE `users`
> SET
>
('company','fname','lname','address1','address2','city','state','zip','phone','exte
Okay, I was under the impression that "where" is
implied inthe joins xx.xx = xx.xx . Is that not the
case ?
As a matter of fact, there isn't even a where or like
in my query. Then again myabe that's why I can see
*all* records but not run a search.
Can you please provide an exmample of the col
Forgot to CC the list..
--- Begin Message ---
there is a WHERE on the last line of the statement you sent me.
Where's are in the form of:
WHERE
Yours is in the form:
WHERE
You're not providing anything to compare the latter value to. You can imply
conditions in the join syntax for sure,
Hello,
I need to grab the max value of all of the data in a table grabbing
the max total for each client. Example.
T1
idtotal clientid
1 100 111
2 200 111
3 100 112
4 150 112
I need a query that will grab t
I think maybe there is an implied where in the
generated code, but not in my statement. I'm saying
when I chose "ACCFIN" (as in the referred error
message), the join should be looking at the referred
table , value ACCFIN . e.g. Code_Table.CodeID
(ACCFIN) = MAIN_Table.CodeID (ACCFIN) return label.
From: "blackwater dev" <[EMAIL PROTECTED]>
I need to grab the max value of all of the data in a table grabbing
the max total for each client. Example.
T1
idtotal clientid
1 100 111
2 200 111
3 100 112
4 150 11
I understand your intent, but that is not really what is happening. The code
changes I suggested did two things:
1) Echo's the error statement that mysql produces
2) Echo's the actual SQL statement that is sent to the DB
you should be looking at #2 for answers, not your intended query. This
Now that I'm not getting an invalid error message any
longer, how can I get it to echo the sql statement ?
Stuart
--- Micah Stevens <[EMAIL PROTECTED]> wrote:
>
> I understand your intent, but that is not really
> what is happening. The code
> changes I suggested did two things:
>
> 1) Echo's
echo $sql." ".$sql_ext;
Read the docs:
http://www.php.net/echo
http://www.php.net/mysql_query
On Friday 10 September 2004 01:18 pm, you wrote:
> Now that I'm not getting an invalid error message any
> longer, how can I get it to echo the sql statement ?
>
> Stuart
>
> --- Micah Stevens <[EMA
pls. help.
i have grant all to one of my tables made in mysql. now when i want to
retrieve the data through PHP, following error is coming
=
select command denied to user: '[EMAIL PROTECTED]' for table
'timeframe'
=
pls. advise what went wrong.
with best wishes
balwant
--
PHP D
17 matches
Mail list logo