zac.carey's articles:

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

Calling Illustrators and Set Designers who use CAD 1 165 (5/22/2009 3:58:08 PM) comp.cad.autocad I teach AutoCAD to pre-foundation students (16-19). In a bid to broaden its appeal, I'm interested in finding examples of (specifically) set designers and illustrators who use CAD extensively in the producti... strawberry

Extract page size from a single-page pdf 2 162 (3/4/2009 9:59:17 AM) comp.text.pdf Hi all, I'm using PHP (on Windows) to extract data from a bunch of single-page PDFs. They are created as such and never subsequently edited (so they were never, for instance, multipage PDFs from which pages we... strawberry

Synching with Outlook 6 49 (2/26/2009 5:55:55 PM) comp.databases.mysql So now I have a nice, normalized MySQL database of organizations and contacts (and much more besides - projects, issue registers, etc). We use MS Outlook for emails. It works well with various portable devices... strawberry

Projects database design 14 59 (12/20/2008 2:37:32 AM) comp.databases.mysql My projects database has a table of projects and a table of contacts. This creates redundancy because several contacts can be affiliated with the same company. Situations also arise where a contact is affiliate... strawberry

Limiting results in a frail pool. 8 41 (4/1/2008 6:58:49 AM) comp.databases.mysql OK, bear with me. This is a big one, and probably one for the gurus, but it seemed like a nice day for it. I have a weak population (a 'frail pool' to use my industry's jargon) made up of several 'population t... strawberry

The Big Sleep 3 124 (10/20/2007 1:39:11 PM) comp.databases.mysql Just curious, is this expected behaviour?: mysql> SELECT GREATEST(SLEEP(3),SLEEP(4)); +-----------------------------+ | GREATEST(SLEEP(3),SLEEP(4)) | +-----------------------------+ | ... strawberry

Updating a view 0 63 (6/14/2007 10:56:10 PM) comp.databases.mysql Here's some tables: food id food 1 banana 2 chicken 3 potato 4 tomato category id category 1 fruit 2 poultry 3 vegetable food_category food_id category_id 1 1 2 2 3 3 4 ... strawberry

UDFs with XAMPP on Windows XP 1 131 (6/1/2007 12:51:51 AM) comp.databases.mysql I've scanned through the manual and a handful of google hits but I'm still unclear, given that I'm using mysql 5.0.33 through xampp on windows XP what steps should I take to incorporate the example UDFs. Where ... strawberry

exploding strings 5 127 (5/18/2007 6:12:29 PM) comp.databases.mysql In a moment or two I'm going to have a table that looks a bit like this: id hyphenated 1 [all-bar-one] 2 [black-and-white] 3 [black-and-blue] 4 [all-for-one] >From which I'd like to generate a result set like ... strawberry

Upgrading 5.0 - 5.1 1 137 (5/17/2007 12:53:34 PM) comp.databases.mysql I'm thinking about upgrading from Mysql 5.0.33 to 5.1.xx, primarily to take advantage of the new XML functionality, and, to a lesser extent, profiling. I habitually use Mysql through Phpmyadmin which I'm loathe... strawberry

zac.carey's replies:

Items(228) /23 Next >> Last >|

Syntax of query? 1 71 (8/5/2011 10:08:31 PM) comp.databases.mysql Hi, I have a simple table with the following data: mysql> select * from mytable; +---------------------+------+ | time_iso | type | +---------------------+------+ | 2011-08-04 00:31:19 | S | | 20... queeux (1)

Strawberry query question #2 22 58 (10/14/2010 7:22:36 PM) comp.databases.mysql I'm trying to group by a column and have the entire row to be returned. The result returned is wrong! I know this is a classic case of a uncorrelated (strawberry) type of query that could be resolve using a mod... servandomontero (161)

Select Query Help 10 142 (9/1/2010 4:30:58 PM) comp.databases.mysql I'm struggling - with my limited knowledge of SQL - to write a query that does what I want it to, and I was hoping that someone here may be able to help out. I have a table with two columns, user1 and us... James

last item of each day 10 92 (11/3/2009 8:48:30 PM) comp.databases.mysql I have a list with entries and each entry has a timestamp. I'd like to show that last entry of each day only, for the last 30 days. How can I do this? Any help is appreciated ... dickreuter (138)

How does MYSQL print to printer? 5 80 (10/19/2009 4:32:53 PM) comp.databases.mysql Does mysql have any output to printer comands? scooper ... robertc47 (7)

database design...sort of 17 33 (9/21/2009 1:34:42 AM) comp.lang.php Im trying to make a PHP web page for some sort of a game for couple friends... and for start im trying to design a database, so ill start with questions, if anyone would like to help. First thing that bothers... ppokazivac (10)

betting query 8 60 (9/13/2009 10:57:28 AM) comp.databases.mysql Hello There is an application where people can bet for matches: 1 x 2. The macthes are create/edited by an admin. The table looks like this: CREATE TABLE IF NOT EXISTS `matches` ( `id` int(10) NOT NULL auto_... sqlquestion77 (3)

Help with a query #4 9 57 (9/12/2009 10:05:34 PM) comp.databases.mysql I am looking to see if there is a better way to get data back in the form: RID RDATA BDATA10 BDATA11 BDATA12 3 FIRST 1_VAL1 2_VAL1 3_VAL1 5 SECOND 1_VAL2 (null) (null) from a query that has c... sheldonlg

How to rewrite this delete statement 32 114 (9/6/2009 6:58:14 PM) comp.databases.mysql I am using MySQL 5.0.27-Community version of MySQL. I have a statemenr I am trying to execute: DELETE FROM channelnotes WHERE id NOT IN ( SELECT id FROM channelnotes ORDER BY tstamp DESC LIMIT 10 ) Which ret... rvince99 (76)

Rotate/Flip/Invert a result set so columns are rows 10 50 (7/8/2009 2:33:01 PM) comp.databases.mysql Hi can someone please let me know the cleanest way to reorder a query result set so the rows are the columns. For example, I have a "settings" table something like this: boxID | title | value 1 | width | 2... cronoklee (177)