Data type Decimal results in Bind parameters failed

oldby

unread,

Feb 28, 2012, 5:57:15 PM2/28/12

to RISE

Hi,

I can't get the Decimal Data type to work - all other types and auto
generated code work like a dance.

I continue to get Bind parameters failed Exception when I use the Data
type Decimal in my model.

Snippet from the auto generated code that fails:
if(!$mysqli_stmt->bind_param('i did......

From my error log I can see:
PHP Warning: mysqli_stmt::bind_param(): Undefined fieldtype
(parameter 3)

System:
Rise Editor 4.5.0.8
mysql Ver 14.14 Distrib 5.1.61, for redhat-linux-gnu (x86_64) using
readline 5.1

Code generators:
PHPforMySQL.exe
MySQL.exe

Any ideas?

Brgds.,
Kasper

oldby

unread,

Feb 28, 2012, 6:46:41 PM2/28/12

to RISE

Notice - there is a " " (whitespace) in the auto generated code for
the mysqli_stmt, I thought it could only be one of: (i|d|s|b)

Brgds.,
Kasper

oldby

unread,

Feb 28, 2012, 7:23:43 PM2/28/12

to RISE

If I alter the auto generated code and add "d" instead of the
whitespace, the Decimal Data type works just fine.

Is this an error in the PHPforMySQL code generator - anyway, what is
the best fix to this problem?

Brgds.,
Kasper

Ola Hellgren

unread,

Feb 29, 2012, 5:15:58 AM2/29/12

to RISE

Hi Kasper,

Thanks for informing us!

There's a fix available. Please, upgrade your PHPforMySQL by starting
the it, from the Windows start menu, and selecting "check for upgrade"
found in the Help menu.

Best regards, Ola

On Feb 28, 11:57 pm, oldby <kas...@oldby.com> wrote:

oldby

unread,

Feb 29, 2012, 5:36:49 AM2/29/12

to RISE

Using it now - it works like dance - thx.

Reply all

Reply to author

Forward