ADODB General Discussion

maxpo10 | 1 Apr 2006 09:05

Sweatshirts / Textile Products Manufacturer [AD]

PROMOWEAR - THE PROFESSIONAL GARMENT MANUFACTURER

COTTON HOODED SWEATER in high-performance, anti-pilling, 100% cotton sweat material, keep the wearer warm, dry and comfortable in all conditions.

Providing in 54 Different Existing Colours.

Quality passing the Azo-Free and ISO Standards.

Embroidery and imprint in customer design logo can be applied on sweaters.

Minimum ordered quantity can be flexible from 100 pcs per colour style.

Ref. SS9001

Ref. SS9002

Ref. SS9003

Ref. SS9010

TRIMMING : EMBROIDERY OR IMPRINT IN CUSTOMER DESIGN LOGO CAN BE APPLIED TO THE SWEATER

Ref. SS9012

Ref. SS9013

Ref. SS9014

Ref. SS9015

MEASUREMENT CHART :

	12	14	16/XS	S	M	L	XL	2XL	3XL	4XL
C.B.L	63	65	67	69	71	73	75	77	79	81
1/2 Chest	54	56	58	60	62	64	66	68	70	72
1/2 Hem	52	54	56	58	60	62	64	66	68	70
Shoulder	46	48	50	52	54	56	58	60	62	64
Armhole	23	24	25	26	27	28	29	30	31	32
Sleeve	58	59	60	61	62	63	64	65	66	67
Cuff	10	10.5	11	11.5	12	12.5	13	13.5	14	14.5

* Measurement in cm.

Import & Export

We can arrange export licence (quota) of sweaters and other knitted quota-need items for the import to your country.

We can also handle the import procedure for you and deliver goods to your warehouse directly.

Cooperation with Us

We would like to cooperate with you to develop mutual business in your markets.

You are always welcome to send us enquiry with your quantity idea and logo artwork details (for embroidery or imprint).

And it is also recommended for you to send us samples of sweaters in your design for our quotation and samping.

If you have any enquiries, please contact us by sending email to promowear <at> sina.com.

Thanks for your kind attention. Awaiting for your further comments.

Best regards.

Charles
promowear <at> sina.com

>>>Designed by Nicklas

------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid

headers

Dan McCullough | 3 Apr 2006 15:35

compile error on adodb ext

I was running ./configure
--with-php-config=/usr/local/php5/bin/php.ini and I get this error.

checking target system type... i686-pc-linux-gnu
/usr/local/php5/bin/php.ini: line 1: [PHP]: command not found
/usr/local/php5/bin/php.ini: line 3: syntax error near unexpected token `;;'
/usr/local/php5/bin/php.ini: line 3: `;;;;;;;;;;;'
/usr/local/php5/bin/php.ini: line 1: [PHP]: command not found
/usr/local/php5/bin/php.ini: line 3: syntax error near unexpected token `;;'
/usr/local/php5/bin/php.ini: line 3: `;;;;;;;;;;;'
configure: error: Cannot find php-config. Please use --with-php-config=PATH

Anyone know how to get around this, my php config file is standard
issue nothing has been changed.

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642

headers

Raine Virta | 22 Apr 2006 20:44

Question regarding AutoExecute

Hi, got one question about adodb.
If I use function like this,

  function sendMsg($post) {
    $this->db->AutoExecute($this->arr_table['message'], $post, 'INSERT');
  } // function

it works fine, however, if table also contains date -field, I want to 
fill it with result of MySQL function NOW().
Is there any simple way to do it? I like the simplicity of AutoExecute, 
but it's not quite clear to me how to use additional MySQL functions 
when INSERTing, same goes for SELECT.

Regards,
Raine Virta

-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

headers

Renne Rocha | 26 Apr 2006 21:56

Problem using Insert_ID() method

Hello,

I have a PostgreSQL table with a SERIAL type field (my primary key). After an insert I would like to retrieve the last ID inserted. I tried to use the method Insert_ID() (with the connection object and after with the recordset object), but I got the following message:

Fatal error: Call to undefined function: insert_id() in /home/xpto/my_file.php on line 21

I haven´t found anything in the documentation of ADODB, neither on the Internet (Google). Anyone could help me with this?

Thanks a lot.

Renne Rocha

The code I am trying to use is something like this:
<?php
$insere = "INSERT INTO contatos (str_nome, str_email, str_telefone, str_funcao) VALUES ('".$str_nome."', '".$str_email."', '".$str_telefone."', '".$str_funcao."')";
if(!$faz_insere = $db->Execute($insere))
{
    print $db->ErrorMsg().'<BR>';
    return false;
} else
{
    $id_contato = $faz_insere->Insert_ID();
    return true;
}
?>

headers

Alfredo Yong | 26 Apr 2006 22:45

Re: Problem using Insert_ID() method

Hi Renne,

Serial type, right? then, Postgresql has created a sequence object to serve you with the new keys. Usually serial key sequences are named this way: TABLE_FIELD. So you can ask a new key from that sequence to use it in your INSERT sentence:

$db->GenID('sequence_name');

With our beloved postgreSQL, Insert_ID will provide you with the OID of the last row inserted, and is a method of the connection object.

hope this helps

On 4/26/06, Renne Rocha <rennerocha <at> gmail.com> wrote:

Hello,

I have a PostgreSQL table with a SERIAL type field (my primary key). After an insert I would like to retrieve the last ID inserted. I tried to use the method Insert_ID() (with the connection object and after with the recordset object), but I got the following message:

Fatal error: Call to undefined function: insert_id() in /home/xpto/my_file.php on line 21

I haven´t found anything in the documentation of ADODB, neither on the Internet (Google). Anyone could help me with this?

Thanks a lot.

Renne Rocha

The code I am trying to use is something like this:
<?php
$insere = "INSERT INTO contatos (str_nome, str_email, str_telefone, str_funcao) VALUES ('".$str_nome."', '".$str_email."', '".$str_telefone."', '".$str_funcao."')";
if(!$faz_insere = $db->Execute($insere))
{
    print $db->ErrorMsg().'<BR>';
    return false;
} else
{
    $id_contato = $faz_insere->Insert_ID();
    return true;
}
?>

--
Alfredo Yong
Sistemas web

headers

burtonl | 27 Apr 2006 16:34

possible to call stored procedures with custom types?

Hi,

Is it possible to call stored procedures that use custom types?

Example:

CREATE OR REPLACE TYPE varchar2_3200_array IS TABLE OF VARCHAR2(3200);

/

CREATE OR REPLACE TYPE number_array IS TABLE OF NUMBER;

/

function signature:

PROCEDURE test

( key_tbl OUT NOCOPY VARCHAR2_3200_ARRAY,

value_tbl OUT NOCOPY NUMBER_ARRAY,

refresh_type IN VARCHAR2

)

If so, can you give me an example?

thanks for any help!

headers

Alejandro Michelin Salomon ( Adinet | 29 Apr 2006 15:32

AttributeError: 'NoneType' object has no attribute 'Connect'

Hi :

I am tring tu use adodb for python.

Y install the extension psycopg.

Then i run the install script, to install adodb.

This installs ok.

I make a test probram coping from the manual

This code :

import adodb;

conn = adodb.NewADOConnection('postgres')

conn.Connect('localhost','probrax','pepe','probrax') --> Error is here.

cursor = conn.Execute('select * from users')

while not cursor.EOF:
print cursor.fields
cursor.MoveNext()

cursor.Close()
conn.Close()

When i try tu execute, program says error.

Message :

Traceback (most recent call last):
File "D:\projetos\todolist\todolist.py", line 9, in ?
conn.Connect('localhost','probrax','pepe','probrax')
AttributeError: 'NoneType' object has no attribute 'Connect'

Can you help me ?

What is hapening ?

Thanks in advance.

Alejandro Michelin Salomon

Porto Alegre

Brasil.

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/326 - Release Date: 27/4/2006

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/326 - Release Date: 27/4/2006

1	June 2013
4	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

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