marksmith5555's articles:

Items(49) /5 Next >> Last >|

Initialising a new column with random values? 28 267 (7/20/2010 9:16:49 AM) comp.databases.mysql Hi, I am trying to add a new column to a table and I would like to initialise them all to different random values. My first attempt was this: ALTER TABLE Users ADD COLUMN `Pin` CHAR(4) NOT NULL DEFAUL... Mark

SHOW ERRORS question 0 170 (3/29/2010 1:13:11 PM) comp.databases.mysql I've been reading the show errors docs (http://dev.mysql.com/doc/ refman/5.0/en/show-errors.html) and I'm having trouble, probably related to my lack of deeper understanding of mysql. Although executing th... Mark

Can I handle AND rethrow exception in mysql? 23 325 (2/22/2010 2:39:11 PM) comp.databases.mysql In some of my larger procs, I have a handler to rollback any transaction and set an out parameter: DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; SET success = -1; END; ... Mark

Where clause does not work on alias for inner select? 2 224 (2/16/2010 12:13:27 PM) comp.databases.mysql This works: SELECT m.CompanyName Name, (SELECT COUNT(*) FROM Cars c WHERE c.CompanyID = m.ID) CarCount FROM Manufacturer m; But when I try to filter based on CarCount it says Unknown column.... Mark

Array transformation question 4 30 (2/9/2010 3:05:43 PM) comp.lang.php If I have an array like: array(1=>"a",2=>"b",3=>"c") What is the fastest way to turn it into: array("a"=>"a","b"=>"b","c"=>"c") ? I've looked at array_flip and some other native php functions, but can't see a... Mark

Null Stack Traces 3 222 (1/29/2010 3:22:56 PM) comp.lang.java.help I just spend ages tracking down a null pointer exception that was being thrown and not caught until somewhere near the top of the application. These types of errors do not have stack traces unfortunately. ... Mark

Textarea width increasing in IE6 0 185 (1/25/2010 4:50:59 PM) comp.infosystems.www.authoring.stylesheets In the following html the width of the text area increases in IE6 outside of the containing div after the user starts typing in it... It works fine in every other browser I've tested. Why? And how should I... Mark

Objects being modified by reference? 3 132 (1/6/2010 5:03:36 PM) comp.lang.php I just spent the last few hours tracking down a bug, that was due to a faulty assumption on my part. I was under the impression that when references to a variable are modified, a copy is created unless the... Mark

Null vs Zero vs Empty String vs Not Set 5 183 (12/15/2009 10:32:12 AM) comp.lang.php I was having some problems yesterday checking data when the data was zero. So I wrote a test script to see exactly how php evaluates different combinations. The fact that it saw null, 0 empty string and an... Mark

File input problem 89 101 (12/4/2009 1:57:42 PM) comp.infosystems.www.authoring.stylesheets I've been spending the last day trying to prettify the file inputs on some forms. CSS support is almost not existent for file inputs on all the major browsers. So I decided to hide the ugly standard fil... Mark

marksmith5555's replies:

Items(27) /3 Next >> Last >|

Initialising a new column with random values? 28 267 (7/20/2010 9:16:49 AM) comp.databases.mysql Hi, I am trying to add a new column to a table and I would like to initialise them all to different random values. My first attempt was this: ALTER TABLE Users ADD COLUMN `Pin` CHAR(4) NOT NULL DEFAUL... marksmith5555 (101)

partial page displayed 9 33 (5/2/2010 1:07:37 PM) comp.lang.php I've been working on a website with my own simple templating. I didn't want to use a framework because this isn't a very large website and I didn't have time to make the learning curve. Anyway this is the ... kevintempler (3)

Array transformation question 4 30 (2/9/2010 3:05:43 PM) comp.lang.php If I have an array like: array(1=>"a",2=>"b",3=>"c") What is the fastest way to turn it into: array("a"=>"a","b"=>"b","c"=>"c") ? I've looked at array_flip and some other native php functions, but can't see a... marksmith5555 (101)

As keyword redundant? 5 33 (11/12/2009 2:52:32 PM) comp.databases.mysql Does the as keyword add any syntactic meaning to a query or is it just for readability. For example, what is the difference between the following? SELECT * FROM TableName as T; SELECT * FROM TableName T; Th... marksmith5555 (101)

Array_unique - odd behavior 5 23 (10/22/2009 11:23:07 AM) comp.lang.php I've just spent the last few hours tracking down an obscure bug and distilled it down to a simple test script that highlights the problem. There are some really strange interactions going on between the php fu... marksmith5555 (101)

Managing state 11 22 (10/15/2009 2:38:16 PM) comp.lang.php I'm working on a project that stores state information in session. (Specifically the ID of the database entity the user is currently working with.) A drawback of this method is that everything gets out of sync... marksmith5555 (101)

Finding trailing spaces 8 33 (10/15/2009 10:04:42 AM) comp.databases.mysql Hi, I am working on a database with many tables with many columns, with many MANY rows. Some of the data that is already loaded is causing unexpected results because it has trailing spaces. Now I have librari... marksmith5555 (101)

Rebuild data dir? 20 112 (9/21/2009 9:19:20 AM) comp.databases.mysql Hi, I am rebuilding my test environment and in the process I deleted the / data directory. Now I can't seem to create a new database even when I am logged in as root: mysql> create database test; ERROR 1006 ... marksmith5555 (101)

Pass out parameter from second stored procedure? 3 48 (9/15/2009 9:09:07 AM) comp.databases.mysql Hi, I am trying to execute stored procedures within a stored procedure. I've tested the sub proc with the same parameters and it works. Now I want to pass the output parameters of the inner stored proc to th... marksmith5555 (101)

Ternary logic question 11 24 (9/9/2009 2:21:29 PM) comp.lang.php I thought you could nest ternary statements, to produce more compact if..then..else if... logic. However the following example is not working as I expect. Since the first expression is true, I would expect th... marksmith5555 (101)