Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: thegman
- Order by date
-
Unicode in Postscript
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...- thegman
- Thread
- Replies: 1
- Forum: PostScript
-
Multi-Threading and Keypresses
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... -
New to C, how to set position in file?
Exactly what I wanted, thanks a lot. Garry -
Establishing Password
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 -
New to C, how to set position in file?
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... -
Auto Increment Stopped Working
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 -
About Privilieges
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 "%". HTH Garry -
Auto Increment Stopped Working
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... -
Erasing Python Objects
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... -
Problems with JOIN
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 -
Problems with JOIN
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... -
AUTO BACKUP
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. -
Hash problems in Perl
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... -
Hash problems in Perl
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... -
mysql 3.20.32a - can't connect remotely
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... -
uploading db?
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... -
database planning
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...- thegman
- Post #2
- Forum: -General database discussion
-
Auto number in a replica database ?
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...- thegman
- Post #2
- Forum: -General database discussion
-
-
UNIQUE keys
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...
