what does the function ZEROFILL do? I got a int(10) field that is unsigned in a mysql table... when i make the field zerofill - it adds 0... eg. 1 becomes 0000000001 Is that the only function it has? Thanks!
Riddle me this.I've built a site on a Linux server that's running Apache. I'm trying to move it over to a new location that's running iPlanet and Solaris. My problem is with passing a session variable on my admin pages. When you hit any page from my admin area, it looks for...
I posted this a day or so ago but I still can't get it to work...I'm doing a very simple blog script.The main blog content is held in one DB and the info for each of the comments in another, with a field for the blog's ID in that DB so I can link the two.What i'm trying to do...
I have a table in my MySQL database which contains two (relevant) columns. the two columns (we'll call them foo and bar) both consist of non-unique integers.I want to select all distinct values of "foo" which contain each of several values for "bar". For example:foo bar----12 3...
Tch! I dunno, you think you can write a simple query, but it doesn't really work!! I have this:$faultQuery = "select * from fault order by fault_id desc";$faultResult = mysql_query($faultQuery,$configDbConnect) or die("Error here"); and of course, I keep getting "Error here" (yes I WILL be...
Dear Sir<br />I have some points in Lat/Lan system.I want to convert them (long set data) to Lambert72 projection.can you guide me how can I do it?if is there any executive file or program please inform me.<br />Best wishes<br />Armi...
For traditional reporting, the dimensions of who, what, and when (customer, product, time), are well covered, however, the "Where" gets little attention. Location Intelligence, the mashup of Business Intelligence with GIS, brings visibility to the "where". Yellowfin's tech tea...
I would like to be able to dial, connect, upload user id's and passwords, and finally send a file with a zmodem portocol. Dial-up is a must, since it is Medicare/Medicaid requirements. I can do everything easily with serialcomm.cc except the zmodem file transfer. Is it capable of this? Hypertermina...
The last day Matt gave a great solution for my problem "How to start a script as soon as I change a field". Zippscript is working really good. But now I would like to go forward and I would like that a script is started when I change the record. For example, if I have three records containing in...
whenenver I try 2 zip up my db(.mdf) file , it givz an error. I can't even copy it to another folder.Do I uncheck the archive in the file properties ?...
What could cause an mdb to have 0% compression when zipped. I import all the tables into a new mdb and get 90% compression when zipped. THe following thread might describe better:http://www.vbforums.com/showthread.php?s=&threadid=195699THanks for any help!...
Hi Mike,Indeed, the problem is IE keeps opening the .doc or the .pps file instead ofthe Saveas dialog.Knowing from you that this can't be done, I now have tried zipping the fileand presenting instead a .zip file and it works fine. No other changes toApache file needed.Thank you for your hel...
I found a great website for inexpensive developer and marketing listsfor zip codes. Plus they give free updates.http://www.listfactor.comThey have lists for united states zip codes, cities, and counties. Ineeded the counties and found that there are ove 3000 in the unitedstates! Didn't know...
Database & Application Miscellaneous Related Categories