Re: Postal code searching

2012-04-24 Thread Grant Allen
That still leaves the question, what are the actual rules/business logic by which you want to group things and get their abbreviations? Are you adhering to Royal Mail/Post Office residual selection/direct selection rules, or do you have your own scheme? It seems like the latter ... the RM

Re: Help with export and import into Oracle

2010-01-12 Thread Grant Allen
machiel.richards wrote: Good day guys [snip] . Each item in the text field is added in the field by entering the country name then pressing enter and then entering the next, etc . When exporting the data to a file (even when enclosing each field within quotes) it still

Re: Unable To Remove User

2009-09-30 Thread Grant Allen
Carlos Williams wrote: On Tue, Sep 29, 2009 at 11:36 PM, mos mo...@fastmail.fm wrote: Why don't you just say Drop User carlos? Also are you logged in as root? In my original message to the board I demonstrated the error I get on my server when I attempt to run the 'drop user

Re: MYSQL startup problem

2008-12-12 Thread Grant Allen
You have ten half-open connections (in SYN_SENT state), and a new connection attempt is giving you error 10055 which is windows' way of saying it can't allocate a buffer for a new connection. Are you running XP SP2 or SP3 or Vista? Microsoft introduced a throttle on in these versions, if

Re: Importing MS SQL exported CSV files adds spaces

2008-11-03 Thread Grant Allen
Ali, Saqib wrote: I exported a large data set from from Microsoft SQL server in CSV format. However whenever I try to import that data to a a mySQL server running on Linux, it adds a space between each character in each field. Essentially: Saqib Ali becomes S a q i b A l i I have tried to use

Re: Migration from Oracle to MySQL

2007-07-26 Thread Grant Allen
Tangirala, Srikalyan wrote: Hi All: Could you provide some more information about Oracle limitations, MySQL limitations, Oracle vs. MySQL etc? Sure, let's play devil's advocate for a minute. Some things unique to MySQL that Oracle does not offer include: - Storage engines, choices like

Re: Convertion ORACLE query to MYSQL

2006-11-09 Thread Grant Allen
On 11/9/06, ViSolve DB Team [EMAIL PROTECTED] wrote: Hi Experts, We are in the process of converting Oracle administration commands into MySQL for some purposes. We dont know how to convert the following Oracle commands to MySQL. How to do that..? 1. ALTER USER spec TEMPORARY TABLESPACE