[gaspower]

Thank you,

That is what I figured.

JR

[gaspower]

Hello Again,

Well I did what you said and used the alter command in the gui, but I get the same error? Too big column length for column set?

Thanks JR

[gaspower]

Hello,

Thank you,

I do have the gui open, and have the alter table open for configuration. If I understand you, I can goto set_function field name and change the (len) from 255 to 555. Also the default is empty which is the same as Null?

Thanks JR

[gaspower]

Hello,

Thank you very much for the reply. I appreciate the explanation, but it goes way over my head… I believe it is 3.23, old. Is there another statement I can use to complete the same job, or another way around the problem.

Thanks again for your time,

JR

[gaspower]

Thank you very much

JR

[gaspower]

Hello,

Thank you for the reply. I am sorry, very new to this, so if I wanted a date range, would it be WHERE `thedate` = '2006-01-05' – '2006-01-10' ?

Thanks JR

[gaspower]

Thank you.

JR

[gaspower]

Hello,

We'll I tried

Select customers_id, customers_firstname, customers_lastname, entry_email_address From customers, address_book Where customers_id = customers_id

And Get Error:

Error Code : 1052

Column: 'customers_id' in field list is ambiguous

(94 ms taken)

Example structure:

Table (address_book)

customer_id

entry_firstname

entry_lastname

Table (customers)

customer_id

customer_email_address

[gaspower]

Thank you,

But when I enter the above into the query window and execute, I get the following error.

Error Code : 1046

No Database Selected

(109 ms taken)

But the correct databases are listed in the statement??

Thans JR

[gaspower]

Hello,

Thank you

[Author]

Posts