Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

id character

Quote Reply
id character
Hi,
does it cause any problems if I change IDīs from only numeric to alphanumeric characters like abc746 abc747 etc.
Thanx for your help
Niko

http://www.master-productions.com
Quote Reply
Re: id character In reply to
For auto-incrementing purposes...yes, it would cause a lot of problems. If you are not auto-incrementing the ID field, then I don't see any problems with changing the field type and also the values in that field.

Regards,

Eliot Lee

Quote Reply
Re: id character In reply to
Thank you very much for your reply. I appreciate very much what you are doing in this forum and your posts have been very helpful for me. We are not auto-incrementing the Data and so it should be fine for us. Thank you again.

Cheers
Niko

http://www.master-productions.com
Quote Reply
Re: id character In reply to
Make sure that you do change the field type from INT or SMALLINT to TEXT or SMALLTEXT in both your tables and also in the .def files.

And you're welcome.

Regards,

Eliot Lee

Quote Reply
Re: [el noe] id character In reply to
Just in case anyone wants to do this: It works AFAICS. Only thing to do is Change

Code:

($id) = $page =~ m,$detail_match/(\d+),;

to

Code:

($id) = $page =~ m,$detail_match/(\w+),;

in Page.pm