Forums

Sign in

E-mail *, (xx@domain.com)
Password *

Register | Forgot password

Active forums

Active Forums RSS September 02, 17:37
Style properties

August 31, 21:46
antrun not found

August 31, 14:12
WCB customprofile

August 31, 12:10
End of flow not doing its job

August 24, 12:37
Sort mediaItem by expiration date

 All Forums...


Data type for IDs in a database page?

The "GX WebManager Usage" forum covers all topics concerning the actual usage of GX WebManager. Topics include using editor functions, content elements, workflow, authorizations, My WebManager, Media repository, Personalization, Page templates, etc.

Answered
Not marked as answered yet

Forums  >  GX WebManager Usage  >  Data type for IDs in a database page?


Author Data type for IDs in a database page?
Cthulhu



Posts: 198

Posted: 14-12-2009 10:12

Hi,

I'm wondering what the type of identifiers is for database pages (or, 'database page models'. Is this an int or a long?

We need to refactor our database to support a certain database page, seems someone used a varchar(50) field for a simple numerical value. However, that value won't fit in an int. So, would it be safe to refactor that to use a bigint?
martinvm



Posts: 59

Posted: 14-12-2009 10:59

For which database? MS SQL, MySQL, Oracle, ... ???
michelt



Posts: 11

Posted: 15-12-2009 11:35

I'd stick to an int to be sure. Have a look at the api class you're dealing with in this case in nl.gx.webmanager.cms.integration

Regards,

Michel

Back to top

New message: "Data type for IDs in a database page?"
Message:
bold boitalicd underline url quote code smile cool eek grin mad razz sad wink
 
© 2010 GX creative online development B.V.

Disclaimer

This website (GXdeveloperweb.com) may discuss or contain opinions, (sample) coding, software or other information that does not include GX official interfaces, instructions or guidelines and therefore is not supported by GX. Changes made based on this information are not supported.  GX will not be held liable for any damages caused by using or misusing the information, software, instructions, code or methods suggested on this website, and anyone using these methods does so at his/her own risk. GX offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this website, including any liability resulting from incompatibility between the content of this website and the materials and services offered by GX. By using this website you will not hold, or seek to hold, GX responsible or liable with respect to the content of this website.