Search results for query: *

A simple question, with what I fear is a very compilcated answer... Basically, I need to put Chinese characters into postscript, but if I do: /STXihei findfont 12 scalefont setfont 100 100 moveto <d750> show I get a chinese character different to the unicode one that d750 represents in my...

Sorry for vague title, but I am having a little trouble with both using PyQT, Python, and QT, all very new versions, problem 1 is: How can I check if Shift/Ctrl/Alt is pressed, I know I can do a keypressevent and a keyrelease event, however this goes wrong if I press shift down over the window...

Exactly what I wanted, thanks a lot. Garry

Log into your database with mysql -u root, assuming you are on the localhost, then type: GRANT ALL ON *.* TO root@localhost identified by 'bocaburger'; That should see you right. Garry

I am reading in a big file (60MB) 5k at a time, which I find is a lot faster than byte-by-byte. The problem is, if the file does not divide exactly by 5k (which it clearly very rarely will), then I miss out on the last bytes of the file, i.e. when my program tries to pick up 5k but cannot get...

Yes, dump the table with mysqldump, make sure all the data is in the file (not sure if it defaults to just the table structure or not), then drop the table and restore from your dump. Garry

GRANT Select,Insert,Delete ON databasename TO user@ip; where databasename is the name of your database, user is your username, and ip is where he will be accessing from, i.e. 10.5.34.102. If he can access from anywhere make ip &quot;%&quot;. HTH Garry

Defining the playerid as smallint is probably your problem with the number maxing out, with regard to the numbers jumping from 500-ish to 32000-ish, then it's probably the fact that ISAM tables (default on MySQL) do not re-use auto-increment numbers, and therefore if you have inserted and...

How is it possible to delete an object on Python, other than use 'del', as I understand that this deincrements the reference count to the object, rather than erase the object itself, I need to erase objects completely, how is this done? I know that if I delete all the references then the object...

Great, that was exactly what I was after. My mistake was not using the table aliases in the WHERE clause of the statement. Doh! Thanks a lot. Garry

I need to get a list of IDs from a table, and then link those IDs up with a 'pretty' name for the same thing in a different table, rather than use a while loop in perl to get these one at a time, which is very slow, I would like to do a JOIN, but I simply cannot get this to work, I either get...

You can do exactly that by setting up a slave system, which will do everything the master system does, and even catch up if the slave is turned off while the master is recieving queries, take a look at the mysql docs, chapter 4.10.3, about 'replication', this is quite easy to set up.

It's OK, I achieved what I wanted, rather than create the reference to the hash in the main subroutine, I passed the hash to a different subroutine, whose only purpose was to make a reference to the hash and pass it back, seems that this will make a unique reference every time, and seemingly...

Is it possible in Perl to create a Hash structure and somehow 'flatten' it so that it may be delievered as an argument to a function without a making a reference to it? The reason I do not want to make a reference is because I want to ditch the real hash to use many times over, and this seems to...

It seems that the usual 'grant all on *.* to .....' does not work on this version of mysql, so I am finding it difficult to set up a user who can access my database server remotely. I altered the user table in the mysql database to have % as host, but it makes no diff. I note that I *can* access...

Assuming your ISP has given you a password, and a host IP for the database, it will be a matter of using mysqldump, in the mysql HTML manual it tells you how to dump straight from your database onto a remote database, all you need is an IP address, user name, and password for the ISP's database...

If I were you, I'd go with 1 query over 8! And you're right, a primary key search will certainly be faster (a lot)than searching for a word, and as your primary key will be a number, it will go faster still, as databases can find numbers faster than text. I think the only reason you want...

if you are using something along the lines of MySQL or another SQL-style database, you could make an auto_increment field for your Customer no. This would make the numbers start at 0 and go up by themselves as customers were added. To make the number always be 4-5 digits, it really depends on...

Exactly! Thanks a lot Garry

Is it possible to make a two UNIQUE keys in a MySQL table which work together? i.e. I have two fields in a table, either one can be the non-unique in different records, but not at the same time. so in programming terms, it's like saying if (Value1 is unique AND Value2 is unique) { CANNOT MAKE...