Maris Kalnins
|
Posted: 08/13/2003, 5:51 AM |
|
Hi!
Win2k, PHP4, Apache 3.xx, MySQL4, CodeChargeStudio 2.0.6.1.
I have a codecharge php application where in the start page
I have grid with following properties:
Grid's data source type = SQL
Grid's data source =
SELECT * FROM menu WHERE item_accesslevel like '%{GroupID}%' ORDER BY
inner_order
Time to time I get an error which says:
MySQL error - no database selected
and gives the error execution string:
SELECT COUNT(*) FROM menu WHERE item_accesslevel like '%0%'
Hitting page refresh several times I get it work.
This occures sometimes but I cannot figure out why
Any ideas?
Thanks, Maris
|
|
|
DonB
|
Posted: 08/13/2003, 6:09 AM |
|
It sounds like it may be a timeout problem. But, consider this as well:
http://snurl.com/21hf
which suggests the way you defined your database connection (DSN) is
possibly the culprit.
DonB
http://www.gotodon.com/ccbth
"Maris Kalnins" <proximus@e-teliamtc.lv> wrote in message
news:bhdc93$qnf$1@news.codecharge.com...
> Hi!
>
> Win2k, PHP4, Apache 3.xx, MySQL4, CodeChargeStudio 2.0.6.1.
>
> I have a codecharge php application where in the start page
> I have grid with following properties:
>
> Grid's data source type = SQL
> Grid's data source =
> SELECT * FROM menu WHERE item_accesslevel like '%{GroupID}%' ORDER BY
> inner_order
>
> Time to time I get an error which says:
>
> MySQL error - no database selected
> and gives the error execution string:
> SELECT COUNT(*) FROM menu WHERE item_accesslevel like '%0%'
>
> Hitting page refresh several times I get it work.
> This occures sometimes but I cannot figure out why
>
> Any ideas?
>
> Thanks, Maris
>
>
|
|
|
|