Posts by pty

yea I do mainly because
1. I already won the blog thing
2. My podcast sucks and I never do anthing for it

Yea I like the vista theme hopefully someone is working on making a customizable Uslab to look like vista. I went with the Mac OS X icons because well they look good and I have vista icons on my XP and my sister or someone would probably get confused and thing they were in windows.

it looks good. i've spent a while playing around with ubuntu/compiz/xgl/cgwd with decent results but i found that i'm just more productive with a 'clear' desktop and 2 normal looking default toolbars.

still though, while im waiting for evolution to download my mail i cant resist giving the progress window a quick wobble

I'm currently trying to create a program in delphi to call up a webpage; the page is written in php and records some data about its contents for record-keeping in my system. I'd like to be able to write the program so that when it opens it does the following:

1. Opens the webpage. I can do this, I found the code to open an application via ShellApi some time ago and it works just as well for a web url as for a file path.

2. Closes the webpage. I only really need to run the page once to do the job, and if the program can close the page afterwards it should. Again, I found some code on how to do this, so that's not really a problem, although I may need to build in a delay; as currently written, it doesn't like to close the page. This isn't critical though, it's merely my own personal aesthetics.

3. Closes the program itself. I know you can close a program with a single form (all this one has) by using the form.close procedure, except that this doesn't work when the statement is included in the form.formcreate procedure, and that's where I'm hoping to call it from.

Is it even possible to code my program so it fits this set of instructions, or should I start looking for a workaround?

Thanks in advance,
-EnderX

application.terminate;

Hi,

Is there any way of finding the modal (most frequent) occurrence of a value. I know that mode doesn't exist in the same way that count, avg and max do but is there any way to combine count and max in such a way to find the most frequent value.

I have a table with people doing different types of events and I need to find for each person what the most frequent event type for them is.

Any help would be very appreciated.

Regards
Andy.

select top 1 with ties your_column
from your_table
group by your_column
order by count(*) desc

Well, I finally decided that os is not for me afterall. Its fine for someone who just likes to play games, surf the web, but leaves a lot to be desired for programmers.
Oh humm.

flame or nub. i think the latter

MY REPLY:
What was rowid here. It was giving invalid column name in SQL SERVER. PLZ reply soon.

your auto-incrementing id field

1) FC1 should run fine with a small hard drive so long as you don't install too many packages on it. Probably best to start with a default install then add more as and when you need them

2) Boot speeds depend on the specs of your computer. Shouldn't take much over 90 seconds even an older machine

3) You don't need Windows installed to use Wine.

4) The different distributions use different package managers to manage software. Redhat/Fedora and SuSE use RPM (redhat package manager) to manage packages so in theory they should work together; however it is reccomended that you use Fedora packages with Fedora and SuSE packages with SuSE due to the configuration of the system, dependencies and so on.

Alternatively compiling programs from source should work pretty much the same on any distribution.

In my opinion you are best downloading a later copy of Fedora (or whichever distribution you like most). Versions 4 and 5 (possibly 3 but I dunno) use YUM in addition to RPM. YUM allows easy software installation by automatically finding and installing dependencies for applications. For example to install firefox you'd type

yum install firefox

So for example firefox needs libpng, if it was not installed on your system Yum would download and install that too thus avoiding rpm hell

5) gambas may be what you're after

oh right, so i just put the disk in and it boots from there without messing up windows - where can i get one from?

darren

the first link i gave was a download mirror

http://iso.linuxquestions.org/version.php?version=327

then just burn the disk image, heres how to do it in nero, i'd imagine other cd burning apps are pretty similar

then just put it in and reboot, and hopefully in a couple of mins you will have a nice 3d eye candy desktop. It may not run quite as fast/smooth as a installed one, i dunno i've not tried it - it should give you an indication though

i don't think the beta (or rc1) has xgl/compiz pre-installed cos of the drivers not being open issue.

I found another program like Skype that offers FREE CALLS to us&canada!!!!

http://www.icall.com

I havent tried it yet,but im very tempted too!!

Anyone ever heard of them?

not tried them but I'm a happy gizmo user. looks fairly similar, gizmo allows free calls to 60 countries and has windows, mac and linux clients (but you can access your account through most sip softphones)

or you can try a live cd (boots straight from the CD so you don't actually install the OS). It won't touch your Windows install at all

This link is to a mirror for Kororaa (it is no longer officially distributed by them because they aren't really allowed to include proprietary ATi and nVidia drivers), you just need a fairly decent nVidia or ATi graphics card and preferebly >256MB RAM.

Hello,

I was wondering if there anyway to Select rows where the date column falls into a certain range?

For example, heres a table

Copy to Clipboard

The date field is generated automatically by MySQL with the DATE function

Heres the table:

[user] . [wins].  [date]
bobby.......4..... 2006-08-21
boby1.......3..... 2006-08-22
boby2.......6..... 2006-08-24
boby3.......1..... 2006-08-29

Now I need to filter this data out so that I can have the end user browse weekly results. I'm stuck on a SELECT syntax statement that can pull any rows from any dates ranging from 8-21 to 8-27 (Monday to Sunday this month).

If this was the case, the last row , boby3 who has 1 wins on 08-29 will not be displayed for this current week's result.

I already have this which ranks users OVERALL season wins:
SELECT user, sum(wins) from results GROUP BY user ORDER by wins

Does anyone know any referrences regarding this issue?

Thanks for reading this,
Bobby

select *
from table
where date >= [start date] and date <= [end date]

or (i'm not 100% sure if this works in mysql but it does in postgres!)

select * 
from table 
where date between [start date] and [end date]

this open source app may be of use to you.

similar programs for mac and linux

Not until Vista as far as I know

Hello everyone.
What languages are being used for instant messaging? Seems to me to be Java or PHP, but I'm not really sure. Can someone explain in a nutshell?
Thanks.

Instant messaging where?

Only Java based IM client I know of is dMSN.

And the only PHP one is meebo.com (which uses libgaim behind the scenes anyway)

I have roughly 600 albums. So much of it I haven't listened to for years though - stuff like RHCP and Foo Fighters. What was I thinking when I bought or ripped them off friends?

Now I spend 90% of my time listening to Motown (Mum's influence) or Folk (Dad's) or old Hiphop.

Occasionally though its nice to be able to thumb through and find something I've not heard for ages and relive my youth with mid 90's indie rock and roll (Charlatans, Oasis, Blur, Super Furry Animals)

Hi there,

I am 18, in my second year of A Levels in the UK. For my computing course this coming year, I must choose to program a project which will be practically used by somebody. At this I have drawn a blank having asked around.

Getting an A in my AS computing examination this year - and 94%, I am a fairly competent programmer, and a lot of time will be invested into the project. It will therefore be of a a fairly decent standard.

Previous projects in previous years have included a 'recording studio' and a invoicer for a tennis club. Last year I programmed a booking system for a village hall and it achieved an 'A' grade. The project would have to have a little input from the client, to specify exactly what they're after, review the programs progress, etc. The program would have 6 months investment and would be completed around April 2007.

I'm not really sure if I'm asking the right people in this forum but if you have any programming projects you think may be appropriate or you know of anyone who would need something please do reply! I welcome any suggestions and will get back to anyone as soon as I can! Obviously I would work for free as it will be as much for my benefit as it is for yours!

Kind Regards

I had the same dilemma when I was doing my A-Levels - my advice would be to ask around …

yeah - didn't realise it was the python forum because I just clicked in from RSS :)

i presume you don't have access to change the firewall settings.

i'm no python expert so i got this from here:

mytunnel.py

#!/usr/bin/python

import socket

def run(host,port):

sd = socket.socket(socket.AF_INET, socket.SOCK_STREAM)

try:

# connect to the given host:port

sd.connect((host, port))

except socket.error:

return 0

else:

return 1

sd.close()

open.tunnel.py

#!/usr/bin/python

import os,mytunnel

command = '/usr/bin/ssh zarski@ssh.server.com -i /root/identity-test/id_rsa -N -L 4000:localhost:3306'

val = mytunnel.run('localhost',4000)

if not val:

pipe=os.popen(command,'r')

pipe.close()

You should be able to use that principle to open a tunnel from your app then aim your db connection string's host at localhost.

>cls

Arctic Monkeys

as per the first line of my original post, install gnumeric

Hi,
How to convert excel to html in shell prompt
Is there any unix command to do this ? so that I can use that in excel
Vinay

install gnumeric

then use ssconvert

should be something along the lines of:

ssconvert -I Gnumeric_Excel:excel -T Gnumeric_html:html40 file.xls
file.html

I took the plunge and decided to learn PHP.
I bought the book 'Beginning PHP 4' by Chris Lea, Wankyu Choi, Allan Kent, Ganesh Prasad, Chris Ullman
So far its pretty good and I've learned a lot. It'd getting tricky now wioth arrays and implodes and explodes but I'm coping fine. I just wish I had more time to do the excercises. it isnt however as difficult as I thought it would be. It is very similar to basic which I learnt well and is quite logical.
What I could do with is a colection of well commented scripts. Is there comethin glike a collectio nof php scripts anywhere that are very well commented? I find analysing code of a working script is as good a learning tools as you can get.

koders.com may be a decent place to start if you have the type of snippet you want in mind.

if battlefield plays ok i don't think its the card at fault. have you got the latest drivers for your card? have you got the latest version of unreal?

i don't really understand what you want but to make a 3rd table from two others you can use the following:

insert into table3 t3 (columns you want)
select (columns you want)
from table1 t1
join table2 t2 on t2.t1_id = t2.id

when its hot i'd generally have a beer. my fridge currently is full of staropramen, leffe and some badger ale

at work i'll have either coffee or tea (yorkshire). i don't drink machine coffee or tea, or anything with non-liquid milk for that matter.

make the two fields unique in combination. it is probably possible in MySQL but this is how to do it in PostgreSQL. If the syntax is different in MySQL you'll have to check the docs

ALTER TABLE navigation_nodes
  ADD CONSTRAINT unq_controller_action_names UNIQUE(controller_name, action_name);
--COMMENT ON CONSTRAINT unq_controller_action_names ON 
--navigation_nodes IS 'make sure same node is not duplicated';

is the file actually there? are you installing from an official microsoft cd?

i like your business plan

1) ?
2) build website about ?
3) profit!

I am facing problem connecting problem connecting remote MySQL server which is firewall protected. I used the valid user name and password, but it throws me the error

OperationalError: (2003, "Can't connect to MySQL server on 'www.myreomtemysqlserver.com' (10061)")

I want to connect from python.

I searched in Google is there anyway so that I can connect MySQL server through SSH. MySQL server is running on UNIX box.

Is there any thing I do on server or is there any package to connect to MySQL which is firewall protected?

Please help me out.

Thanks.

kath.

If the SSH port is open on the server's firewall (22 by default) you should be able to use a SSH tunnel to connect to mysql.

ssh -L [local port]:[mysql host]:[connect-to-port]

Then aim your connection at localhost:[local port]

For mysql the default listen port is 3306

hello all,

i am a fresher ,i don't know from where to start,how to draw the er diagram for my project which is almost like an E-bay site.pls help me by giving ideas regarding this and send me some examples of er diagrams so that i can get idea.

This should help

SELECT product,max(transaction_date)
FROM tbl
GROUP BY product

It actually boots linux from the CD. It won't touch your Windows install but will simply mount your hard drive as a desktop icon. From there you just need to navigate to my documents (or wherever you store your stuff) and copy it somewhere safe for the time being. Once you've got your important things off you're probably best formatting the machine.

If you work in a company with an IT dept they'll already have a copy of knoppix around - most people I know do

It looks like this: http://www.linuxsoft.cz/img2/gamesknoppix/4.0.2/m05.png

When I start windows in regular or safe mode I get "explorer has caused and invalid page error in module browseui.dll", and that's as far as it goes. I've re-installed windows and got to the point where it was basically working but then all of the sudden it goes back. I've tried 8 times (not exaggerating) and I just can't get past that one point. I would just reformat but I've got several professional files on there that I really need to put onto disk. Any suggestions would be appreciated!
If all else fails, can I take my harddrive to someone to access and copy the files? I want to buy a new one anyway, my work files are the only thing dragging this on....
Thanks

My advice would be to get hold of a knoppix cd, obviously as your computer is in a state you may need a friend with broadband to download and burn it.

You can then boot the OS without affecting your windows install, Knoppix then mounts the windows drive and puts the shortcut on your desktop - this will allow you to salvage your important files (put them on a usb drive or save them in your webmail account or something).

I don't know how much RAM you have, Knoppix may be a big sluggish with less than 128mb (but it should still work).

I like ubuntu on the desktop because I like Gnome and I like having all my hardware discovered first time.

I run Redhat (well, CentOS) on my servers because I'm more familiar with it (used it since version 7.2).

It all depends on how you look at it. Here's Macworld's analysis:

You can do no damage to OSX while logged in as a normal user. Its UNIX origins don't allow you to make changes to vital parts of the system without having root privileges.

The problem is that some muppets just type their password in whenever the box pops up - thats how it spreads.

Its not clever, it doesn't exploit the system in any advanced way, it exploits dumbass users who deserve what they get. In my opinion it shouldn't be classed as a virus. Argue away at malware, etc, but if people have to acknowledge that its being installed its not a virus.

It probably gets the same crowd who gave £3,000 to Mr Henry Onwonku personal aide to the former bank manager of the Royal Bank of Nigeria so that he can obtain the safe key to the deposit box containing $12,140,423 (Twelve Million, One Hundred and Forty Thousand, Four Hundred and Twenty Three Dollars) and share it with them.

Thanks a lot, that helps.
I am still learning php and my sql, heck I am still in high school and taught everything myself so I know I will make mistakes and not know many things. Also I need people who tell me i dont know this and that because that is what motivates me to learn:lol: ...
Thanks again

No problem. I when you said 'i have two servers' I assumed you were talking about work.

If you're starting I recommend this. Also, the php docs are always going to be useful as are the MySQL (and no doubt Apache) ones.

$connection = mysql_connect(IP_ADDRESS_OF_DATABASE_SERVER:PORT_YOU_SET_MYSQL_TO_LISTEN_ON, DB_USER, DB_PASS)
   or die("Query failed : " . mysql_error());
$db = mysql_select_db(DB_NAME, $connection)
   or die("Query failed : " . mysql_error());

I shouldn't be telling a programmer what 'host' means. Seriously; learn to walk before you run.

Try reading this

As I stated before, there are viruses for Macs.
http://www.symantec.com/press/1998/n980714.html

I'm not saying that Macs are better than PCs. I'm not trying to defend Apple. I am simply saying that you are not being very helpful on this forum (do you even own a Mac??!), so keep out of this if you are not interested in other people's Mac problems.

Symantec would say that so people think 'oh noes - there are mac virii and I don't have AV software!!'.

This 'virus' (trojan) IMs itself to your buddies. They have to accept the file, decompress it, double click it and then enter their admin password to install it. It is not a virus.

Symantec (and McAfee, Sophos etc) are just crapping themselves because Vista *may* come with a built in windows AV package (or hell, it may even be secure)

I have two servers and one of them have mysql db and one doesnt so is it possible to use mysql db in my other server while hosting my website on another. also if there is how would you do it with php.

Just set the host parameter of the mysql_connect function to the IP address of the other server. You'll also need to open the MySQL port (3306) on the other server if it's closed

To be honest I'm no MySQL expert (PostgreSQL fan) but it seems that MySQL has just skipped the inserts that would cause problems:

Query OK, 0 rows affected (0.03 sec)
Records: 10  [b]Duplicates: 10[/b]  Warnings: 0

In PostgreSQL you'd get:

ERROR:  duplicate key violates unique constraint "constr_active_level_type"

Google's interactive page was made using a technology called AJAX.

If you google for AJAX tutorials you'll find lots, there have been numerous ones on digg too.

I'm not reccomending any here because it depends on what technologies you're using (.net/php/ruby on rails/python etc)

Copy to Clipboard

mysql> insert into fund_history select * from temp_fund_history 
where data_date='2006-06-30' and index_num between 1 and 10;

Query OK, 0 rows affected (0.03 sec)
Records: 10  Duplicates: 10  Warnings: 0

I am really wondering why this INSERT statement is not inserting 10 records. Its saying 10 Duplicates: 10, and there is no records from index_num from 1 to 10 in fund_history table.

Can any one please help me to know the reason/cause and solution for this problem.

Thanks,
Kath

do any of your fields have a unique constraint?

yes. thought so.

I started with Pascal and Delphi towards the end of school, then used it while at uni along with C++ and some VB

Pascal is just not 'fashionable' at the moment. It is an excellent language to begin with and has no 'real' disadvantages other than its image.

If I need to write a Windows app quickly though (i work as a contractor so that is fairly regular) Delphi (7) is still my tool of choice. Quick development, runs extremely quickly, code is in a readable state.. its all good.

Hi,

I want to know how i can set up a PC as a webserver. Please let me know what the intricacies involved in running it as a server. i know about IIS or Apache and smiliar servers and i also do web designing, but i want to put my own server. please let me know how.

Thanks

Do you want to set the server up for local testing purposes or for hosting a site from home?

In my opionion, if you want to host a personal site you can get good hosting deals for a few pounds per month - means you don't have to keep a machine running at home, will load faster and won't be affected if your connection goes down.

To get apache running simply download the apache installer (or for apache/php/mysql try xampp), then start the service using either the shortcut in the start menu or using the services box in the administrive tools.

For IIS, put your XP disk in the drive, go to add/remove programs and its in the menus there somewhere. I never really used IIS but I'm sure you can find lots of info in this forum or from MS's help forums.

Make sure that port 80 is open on your firewall and you should be good to go

I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this?

select id from mytable mt where (mt.id % 5) = 0

you cant get MySQL-Max 4.1.20 from their site; not the exact version you specify but pretty close, only bugfixes and minor changes afaik

Wow. Good job!

sqlite?

I'm having problem in inserting into table. I'm inserting data from one table into another

insert into table1 select * from table2 where condition = expression

I have 962 records in table2 for specified condition, but only 105 rows are getting inserted.

Both tables are in same database.

What could be problem? Please help me to get out of this problem.

your expression is probably wrong, however, it is difficult to diagnose unless you post it and some of your schema