Oh, I have no desire to actually switch, I'm perfectly happy with XP. I just want to have the upgrade CD in my possession.
I always thought the name Serenity had a vaguely funereal sound to it.
Simon ,'Out Of Gas'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Sean K - Apr 02, 2007 6:41:18 pm PDT #1122 of 25496
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
§ ita § - Apr 02, 2007 7:35:41 pm PDT #1123 of 25496
Well not canonically, no, but this is transformative fiction.
Anyone do PHP PostgreSQL programming? I'm wondering if there's some sort of PGSQL equivalent to MySQL's mysql_insert_id function.
Kevin - Apr 02, 2007 11:17:23 pm PDT #1124 of 25496
Never fall in love with somebody you actually love.
ita, see towards the bottom of this: [link]
§ ita § - Apr 03, 2007 4:12:06 am PDT #1125 of 25496
Well not canonically, no, but this is transformative fiction.
I'm not sure I ever tested the equivalent on MySQL, but when I thought of retrieving the last serial # in PGSQL it seemed easy enough to get the last serial # but of someone else's more recent transaction. Maybe a stored procedure?
Sophia Brooks - Apr 03, 2007 4:44:07 am PDT #1126 of 25496
Cats to become a rabbit should gather immediately now here
I have a quick Access question. I have a subform with a field that counts the number of records with =Count(*). What I would like to do is exclude some people from that count, ones who have a 'Yes' in the the field "Cancelled". Is this possible easily? (If it isn't, I don't need anyone to spend a lot of time on it)
THanks
tommyrot - Apr 03, 2007 4:50:56 am PDT #1127 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
I have a quick Access question. I have a subform with a field that counts the number of records with =Count(*). What I would like to do is exclude some people from that count, ones who have a 'Yes' in the the field "Cancelled". Is this possible easily? (If it isn't, I don't need anyone to spend a lot of time on it)
Yeah, it's simple. Say the subform has the recordsource "myQuery", then you could use the DCount like this:
=dCount("*","myQuery","Cancelled=Yes")
Assuming Cancelled is a binary field. If it's a text field, put the 'Yes' inside single quotes.
Is that what you wanted?
Sophia Brooks - Apr 03, 2007 4:52:31 am PDT #1128 of 25496
Cats to become a rabbit should gather immediately now here
Thanks! It is exactly what I wanted!
Sophia Brooks - Apr 03, 2007 5:03:11 am PDT #1129 of 25496
Cats to become a rabbit should gather immediately now here
Oh- Except for the record source is (I think) an SQL statement that is SELECT DISTINCT ROW [Studentsandclasses]-- does that make a difference?
tommyrot - Apr 03, 2007 5:04:54 am PDT #1130 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
No. Just put the SQL statement inside the quotes where the query/table name would otherwise go.
Sophia Brooks - Apr 03, 2007 5:06:28 am PDT #1131 of 25496
Cats to become a rabbit should gather immediately now here
Thanks!