ADODB General Discussion

Alejandro Michelin Salomon | 5 Jul 2005 16:11

GetMenu, Adding funcionality

Hi :

I test the GetMenu method of ADORecordSet class.

I get a nice select tag with data from my database.

My code without getmenu :

function CargoNiveis( $idnivel, $Connection )
{
$sSql  = " SELECT idnivel, descricao ";
$sSql .=   " FROM co_niveis ";
$sSql .=  " ORDER BY descricao ";

$rs = $Connection->Execute( $sSql );

if ( !$rs )
    exit(" Erro : ao Procurar Niveis = > " . mysql_error());

print "<option value=\"20\" selected>Escolha um Nivel</option>"; <---
this line i cannot add with GetMenu.

while ( !$rs->EOF )
{
    if ( $rs->fields["idnivel"] == $idnivel )
        print "<option value=\"{$rs->fields["idnivel"]}\"
selected>{$rs->fields["descripcao"]}</option>";
    else
        print "<option
value=\"{$rs->fields["idnivel"]}\">{$rs->fields["descripcao"]}</option>"

(Continue reading)

headers

Alejandro Michelin Salomon | 6 Jul 2005 14:42

RES: GetMenu, Adding funcionality

Hi :

I solved the problem, reading the adodb code.

GetMenu($name, [$default_str=''], [$blank1stItem=true],
[$multiple_select=false], [$size=0], [$moreAttr=''])

The parameter $blank1stItem, can be false, true, or a string with this
format ( '{value}:{description}' ).

{value}       --> Value to value attribute.
:             --> Separator
{description} --> Description to see.

This is the code without blank item :

$rs->GetMenu( 'teste', $idnivel, false, false, 0, $sStyle );

This with blank item :

$rs->GetMenu( 'teste', $idnivel, '20:Escolha um Nivel', false, 0,
$sStyle );

Note :
The adodb documentation does not say that parameter $blank1stItem, can
be a string.

Alejandro M.S

-----Mensagem original-----

(Continue reading)

headers

Paul Tugwell | 7 Jul 2005 11:00

Return error value from stored procedure

I am new to ADOdb, so please excuse me if this is a stupid question

I have a stored procedure that when send a string read from a barcode, decodes the string into several parts then checks whether a record exists in a Firebird 1.5 database related to this barcode. This can produce 3 possible results

1) The barcode has an invalid format e.g. it does not contain the expected information

2) The barcode has a valid format, but there is no related record in the database

3) The barcode has a valid format, and a related record exists in the database

Scenarios 1 and 2 each return a different custom message generated by a Firebird exception

Scenario 3 returns a result set

I am using the following code in php

sql = "SELECT BAR_TYPE, COIL, COIL_SX, MATERIAL, QTY, WEIGHT FROM READ_BARCODE('".$_POST["edtBarcode"]."')";

$rs = $conn->Execute($sql);

If a valid barcode is entered, I get the expected result

If an invalid barcode is entered, how do I detect the error message returned?

headers

operationsengineer1 | 8 Jul 2005 17:31

Return error value from stored procedure

are you looking for the error from your stored
procedure?  if so, i'm not sure if the following will
work...

if{ (!$recordSet) 
	print $conn->ErrorMsg();
}else{
...
}

taken from the manual (w/ added if, else brackets)...

http://phplens.com/lens/adodb/docs-adodb.htm#ex1

--- adodb-general-request <at> lists.sourceforge.net wrote:

> Send ADodb-general mailing list submissions to
> 	adodb-general <at> lists.sourceforge.net
> 
> To subscribe or unsubscribe via the World Wide Web,
> visit
> 
>
https://lists.sourceforge.net/lists/listinfo/adodb-general
> or, via email, send a message with subject or body
> 'help' to
> 	adodb-general-request <at> lists.sourceforge.net
> 
> You can reach the person managing the list at
> 	adodb-general-admin <at> lists.sourceforge.net
> 
> When replying, please edit your Subject line so it
> is more specific
> than "Re: Contents of ADodb-general digest..."
> 
> 
> Today's Topics:
> 
>    1. Return error value from stored procedure (Paul
> Tugwell)
> 
> --__--__--
> 
> Message: 1
> Date: Thu, 7 Jul 2005 10:00:57 +0100
> From: "Paul Tugwell" <Paul <at> guardbase.co.uk>
> To: <adodb-general <at> lists.sourceforge.net>
> Subject: [ADodb-general] Return error value from
> stored procedure
> 
> This is a multi-part message in MIME format.
> 
> ------_=_NextPart_001_01C582D2.6385AC58
> Content-Type: text/plain;
> 	charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
> 
> I am new to ADOdb, so please excuse me if this is a
> stupid question
> 
> =20
> 
> I have a stored procedure that when send a string
> read from a barcode,
> decodes the string into several parts then checks
> whether a record
> exists in a Firebird 1.5 database related to this
> barcode. This can
> produce 3 possible results
> 
> 1) The barcode has an invalid format e.g. it does
> not contain the
> expected information
> 
> 2) The barcode has a valid format, but there is no
> related record in the
> database
> 
> 3) The barcode has a valid format, and a related
> record exists in the
> database
> 
> =20
> 
> Scenarios 1 and 2 each return a different custom
> message generated by a
> Firebird exception
> 
> Scenario 3 returns a result set
> 
> =20
> 
> I am using the following code in php
> 
> =20
> 
> sql =3D "SELECT BAR_TYPE, COIL, COIL_SX, MATERIAL,
> QTY, WEIGHT FROM
> READ_BARCODE('".$_POST["edtBarcode"]."')";
> 
> $rs =3D $conn->Execute($sql);
> 
> =20
> 
> If a valid barcode is entered, I get the expected
> result
> 
> =20
> 
> If an invalid barcode is entered, how do I detect
> the error message
> returned?
> 
> =20
> 
> 
> ------_=_NextPart_001_01C582D2.6385AC58
> Content-Type: text/html;
> 	charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
> 
> <html
> xmlns:o=3D"urn:schemas-microsoft-com:office:office"
> =
> xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns=3D"http://www.w3.org/TR/REC-html40">
> 
> <head>
> <meta http-equiv=3DContent-Type
> content=3D"text/html; =
> charset=3Dus-ascii">
> <meta name=3DGenerator content=3D"Microsoft Word 11
> (filtered medium)">
> <style>
> <!--
>  /* Style Definitions */
>  p.MsoNormal, li.MsoNormal, div.MsoNormal
> 	{margin:0cm;
> 	margin-bottom:.0001pt;
> 	font-size:10.0pt;
> 	font-family:Arial;}
> h1
> 	{margin-top:0cm;
> 	margin-right:0cm;
> 	margin-bottom:12.0pt;
> 	margin-left:0cm;
> 	page-break-after:avoid;
> 	font-size:16.0pt;
> 	font-family:Arial;
> 	text-decoration:underline;}
> h2
> 	{margin:0cm;
> 	margin-bottom:.0001pt;
> 	page-break-after:avoid;
> 	font-size:10.0pt;
> 	font-family:Arial;
> 	text-decoration:underline;}
> h3
> 	{margin:0cm;
> 	margin-bottom:.0001pt;
> 	page-break-after:avoid;
> 	font-size:10.0pt;
> 	font-family:Arial;}
> a:link, span.MsoHyperlink
> 	{color:blue;
> 	text-decoration:underline;}
> a:visited, span.MsoHyperlinkFollowed
> 	{color:purple;
> 	text-decoration:underline;}
> span.EmailStyle17
> 	{mso-style-type:personal-compose;
> 	font-family:Arial;
> 	color:windowtext;}
>  <at> page Section1
> 	{size:595.3pt 841.9pt;
> 	margin:2.0cm 2.0cm 2.0cm 2.0cm;}
> div.Section1
> 	{page:Section1;}
> -->
> </style>
> 
> </head>
> 
> <body lang=3DEN-GB link=3Dblue vlink=3Dpurple>
> 
> <div class=3DSection1>
> 
> <p class=3DMsoNormal><font size=3D2
> face=3DArial><span =
> style=3D'font-size:10.0pt'>I am
> new to ADOdb, so please excuse me if this is a
> stupid =
> question<o:p></o:p></span></font></p>
> 
> <p class=3DMsoNormal><font size=3D2
> face=3DArial><span =
>
style=3D'font-size:10.0pt'><o:p>&nbsp;</o:p></span></font></p>
> 
> <p class=3DMsoNormal><font size=3D2
> face=3DArial><span =
> style=3D'font-size:10.0pt'>I
> have a stored procedure that when send a string read
> from a barcode, =
> decodes
> the string into several parts then checks whether a
> record exists in a =
> Firebird
> 1.5 database related to this barcode. This can
> produce 3 possible =
> results<o:p></o:p></span></font></p>
> 
> <p class=3DMsoNormal><font size=3D2
> face=3DArial><span =
> style=3D'font-size:10.0pt'>1)
> The barcode has an invalid format e.g. it does not
> contain the expected
> information<o:p></o:p></span></font></p>
> 
> 
=== message truncated ===

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-------------------------------------------------------
This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
core and dual graphics technology at this free one hour event hosted by HP, 
AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar

headers

Paul Tugwell | 8 Jul 2005 17:57

RE: Return error value from stored procedure

Thanks for the reply. That's what I tried before sending the e-mail.
Unfortunately !$recordset seems to always to be false whether the stored
procedure has returned a result set or an error message, so the else
clause is always invoked.

-----Original Message-----
From: adodb-general-admin <at> lists.sourceforge.net
[mailto:adodb-general-admin <at> lists.sourceforge.net] On Behalf Of
operationsengineer1 <at> yahoo.com
Sent: 08 July 2005 15:32
To: adodb-general <at> lists.sourceforge.net
Subject: [ADodb-general] Return error value from stored procedure

are you looking for the error from your stored
procedure?  if so, i'm not sure if the following will
work...

if{ (!$recordSet) 
	print $conn->ErrorMsg();
}else{
...
}

taken from the manual (w/ added if, else brackets)...

http://phplens.com/lens/adodb/docs-adodb.htm#ex1

--- adodb-general-request <at> lists.sourceforge.net wrote:

> Send ADodb-general mailing list submissions to
> 	adodb-general <at> lists.sourceforge.net
> 
> To subscribe or unsubscribe via the World Wide Web,
> visit
> 
>
https://lists.sourceforge.net/lists/listinfo/adodb-general
> or, via email, send a message with subject or body
> 'help' to
> 	adodb-general-request <at> lists.sourceforge.net
> 
> You can reach the person managing the list at
> 	adodb-general-admin <at> lists.sourceforge.net
> 
> When replying, please edit your Subject line so it
> is more specific
> than "Re: Contents of ADodb-general digest..."
> 
> 
> Today's Topics:
> 
>    1. Return error value from stored procedure (Paul
> Tugwell)
> 
> --__--__--
> 
> Message: 1
> Date: Thu, 7 Jul 2005 10:00:57 +0100
> From: "Paul Tugwell" <Paul <at> guardbase.co.uk>
> To: <adodb-general <at> lists.sourceforge.net>
> Subject: [ADodb-general] Return error value from
> stored procedure
> 
> This is a multi-part message in MIME format.
> 
> ------_=_NextPart_001_01C582D2.6385AC58
> Content-Type: text/plain;
> 	charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
> 
> I am new to ADOdb, so please excuse me if this is a
> stupid question
> 
> =20
> 
> I have a stored procedure that when send a string
> read from a barcode,
> decodes the string into several parts then checks
> whether a record
> exists in a Firebird 1.5 database related to this
> barcode. This can
> produce 3 possible results
> 
> 1) The barcode has an invalid format e.g. it does
> not contain the
> expected information
> 
> 2) The barcode has a valid format, but there is no
> related record in the
> database
> 
> 3) The barcode has a valid format, and a related
> record exists in the
> database
> 
> =20
> 
> Scenarios 1 and 2 each return a different custom
> message generated by a
> Firebird exception
> 
> Scenario 3 returns a result set
> 
> =20
> 
> I am using the following code in php
> 
> =20
> 
> sql =3D "SELECT BAR_TYPE, COIL, COIL_SX, MATERIAL,
> QTY, WEIGHT FROM
> READ_BARCODE('".$_POST["edtBarcode"]."')";
> 
> $rs =3D $conn->Execute($sql);
> 
> =20
> 
> If a valid barcode is entered, I get the expected
> result
> 
> =20
> 
> If an invalid barcode is entered, how do I detect
> the error message
> returned?
> 
> =20
> 
> 
> ------_=_NextPart_001_01C582D2.6385AC58
> Content-Type: text/html;
> 	charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
> 
> <html
> xmlns:o=3D"urn:schemas-microsoft-com:office:office"
> =
> xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns=3D"http://www.w3.org/TR/REC-html40">
> 
> <head>
> <meta http-equiv=3DContent-Type
> content=3D"text/html; =
> charset=3Dus-ascii">
> <meta name=3DGenerator content=3D"Microsoft Word 11
> (filtered medium)">
> <style>
> <!--
>  /* Style Definitions */
>  p.MsoNormal, li.MsoNormal, div.MsoNormal
> 	{margin:0cm;
> 	margin-bottom:.0001pt;
> 	font-size:10.0pt;
> 	font-family:Arial;}
> h1
> 	{margin-top:0cm;
> 	margin-right:0cm;
> 	margin-bottom:12.0pt;
> 	margin-left:0cm;
> 	page-break-after:avoid;
> 	font-size:16.0pt;
> 	font-family:Arial;
> 	text-decoration:underline;}
> h2
> 	{margin:0cm;
> 	margin-bottom:.0001pt;
> 	page-break-after:avoid;
> 	font-size:10.0pt;
> 	font-family:Arial;
> 	text-decoration:underline;}
> h3
> 	{margin:0cm;
> 	margin-bottom:.0001pt;
> 	page-break-after:avoid;
> 	font-size:10.0pt;
> 	font-family:Arial;}
> a:link, span.MsoHyperlink
> 	{color:blue;
> 	text-decoration:underline;}
> a:visited, span.MsoHyperlinkFollowed
> 	{color:purple;
> 	text-decoration:underline;}
> span.EmailStyle17
> 	{mso-style-type:personal-compose;
> 	font-family:Arial;
> 	color:windowtext;}
>  <at> page Section1
> 	{size:595.3pt 841.9pt;
> 	margin:2.0cm 2.0cm 2.0cm 2.0cm;}
> div.Section1
> 	{page:Section1;}
> -->
> </style>
> 
> </head>
> 
> <body lang=3DEN-GB link=3Dblue vlink=3Dpurple>
> 
> <div class=3DSection1>
> 
> <p class=3DMsoNormal><font size=3D2
> face=3DArial><span =
> style=3D'font-size:10.0pt'>I am
> new to ADOdb, so please excuse me if this is a
> stupid =
> question<o:p></o:p></span></font></p>
> 
> <p class=3DMsoNormal><font size=3D2
> face=3DArial><span =
>
style=3D'font-size:10.0pt'><o:p>&nbsp;</o:p></span></font></p>
> 
> <p class=3DMsoNormal><font size=3D2
> face=3DArial><span =
> style=3D'font-size:10.0pt'>I
> have a stored procedure that when send a string read
> from a barcode, =
> decodes
> the string into several parts then checks whether a
> record exists in a =
> Firebird
> 1.5 database related to this barcode. This can
> produce 3 possible =
> results<o:p></o:p></span></font></p>
> 
> <p class=3DMsoNormal><font size=3D2
> face=3DArial><span =
> style=3D'font-size:10.0pt'>1)
> The barcode has an invalid format e.g. it does not
> contain the expected
> information<o:p></o:p></span></font></p>
> 
> 
=== message truncated ===

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-------------------------------------------------------
This SF.Net email is sponsored by the 'Do More With Dual!' webinar
happening
July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
core and dual graphics technology at this free one hour event hosted by
HP, 
AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar
_______________________________________________
ADodb-general mailing list
ADodb-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/adodb-general

-------------------------------------------------------
This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
core and dual graphics technology at this free one hour event hosted by HP, 
AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar

headers

operationsengineer1 | 11 Jul 2005 21:04

Return error value from stored procedure

you can ask here...

http://phplens.com/lens/lensforum/topics.php?id=4

also, you can check and see if recordcount = 0 (or is
null, not sure of the behavior or the options).  that
will obviously trigger even if the stored procedure
fires and returns 0 records.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-------------------------------------------------------
This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
core and dual graphics technology at this free one hour event hosted by HP, 
AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar

Mon	Tue	Wed	Thu	Fri	Sat	Sun

				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

2	May 2013
1	April 2013
3	March 2013
1	February 2013
4	January 2013
3	December 2012
2	November 2012
4	October 2012
6	September 2012
2	August 2012
2	July 2012
3	June 2012
4	May 2012
1	April 2012
4	March 2012
1	February 2012
2	January 2012
2	December 2011
3	November 2011
3	October 2011
3	September 2011
3	August 2011
3	July 2011
7	June 2011
4	May 2011
4	April 2011
6	March 2011
2	February 2011
2	January 2011
4	December 2010
2	November 2010
3	October 2010
3	September 2010
3	August 2010
3	July 2010
5	June 2010
2	May 2010
3	April 2010
9	March 2010
4	February 2010
6	January 2010
16	December 2009
2	November 2009
2	October 2009
5	September 2009
15	August 2009
36	July 2009
19	June 2009
35	May 2009
19	April 2009
13	March 2009
13	February 2009
6	January 2009
36	December 2008
21	November 2008
15	October 2008
16	September 2008
1	August 2008
1	July 2008
4	June 2008
8	May 2008
13	April 2008
5	March 2008
6	February 2008
9	January 2008
4	December 2007
7	November 2007
2	October 2007
4	September 2007
5	August 2007
9	July 2007
2	June 2007
1	May 2007
7	April 2007
9	March 2007
7	February 2007
3	January 2007
6	December 2006
2	November 2006
10	October 2006
6	September 2006
9	August 2006
3	July 2006
10	June 2006
6	May 2006
7	April 2006
9	March 2006
8	February 2006
6	January 2006
2	December 2005
10	November 2005
17	October 2005
9	September 2005
4	August 2005
6	July 2005
19	June 2005
7	May 2005
1	April 2005