677 Posted Topics
 | Hi, Rather than using wildcards I think you should try using the [url=http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_trim]trim[/url] function on the string. However if you have a big table this will be slow (but not as slow as wildcards!). Maybe it would be faster if your numbers after the Z were in a separate column? |
| | There are a LOT of very clever people coming out of the Indian educational system. Intel, Fujitsu, Microsoft, Candence, AMD and Oracle are investing in R&D centres out there. Its not just cheap labour - its cheap well-educated labour. I doubt it will be cheap for long.  |
| | You can vastly simplify the granting of permissions by using [url=http://www.postgresql.org/docs/8.4/interactive/sql-creategroup.html]groups/roles[/url].  |
| | [QUOTE=nagaraj530;292365]hi friends, how can i store video files in the server or database like mysql, if u r having any related docs or code. please send it to my mail-id. otherewise tell me the way how can i store. i am waiting for ur replies... ok bye.. thanks in advance.[/QUOTE] … |
| | [QUOTE=apiss_nurz;260958]hai...i want the system able to search the student information,to add,save,delete..but i already done for it..i just dont know what more table shoud i add at least 3 more table...to make it more advance..and i need the coding...[/QUOTE] [url=http://www.databaseanswers.org/data%5Fmodels/]This[/url] may give you some inspiration. I won't give you any code … |
| | [QUOTE=ashneet]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.[/QUOTE] Just set the host parameter of the … |
| | Re: New to Ruby Your text example doesn't really show how the script you provide works. Here's what you are probably after though - this could be a bit more robust but in this state it's clear: [code=ruby] #!/usr/bin/env/ruby #first get the name puts "Enter your name" name = gets #now get a number, … |
| | |
| | [QUOTE=mythri]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.[/QUOTE] [url=http://www.databaseanswers.org/data%5Fmodels/]This[/url] …  |
| | [QUOTE=katharnakh]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 [I]OperationalError: (2003, "Can't connect to MySQL server on 'www.myreomtemysqlserver.com' (10061)")[/I] I want to connect from python. I searched in Google is there … |
| | Looks like a good start. No better way of learning than diving in and trying to actually build something useful!  |
| | [QUOTE=linux;330849]Hmm... I got both of them fixed, with a little work. I copied the whole directory for Ruby onto my flashdrive, and it works! And for the other, it was SciTE that was hanging it.[/QUOTE] Afraid I never tried to run Scite from a flash drive. Have you tried Notepad++? …  |
 | KDE is not supported because this is a LTS release; KDE 4 will be brand new when Ubuntu 8.04 is released and there is no guarantee that the KDE guys will still be writing security updates etc for KDE3.x releases in 3 years time. It simply does not make sense … |
| | Because you all want to see my shiny desktop :) [url]http://homepage.ntlworld.com/pd.yates/screenshots/Screenshot-compiz1.png[/url] [url]http://homepage.ntlworld.com/pd.yates/screenshots/Screenshot-compiz.png[/url]  |
| | Linux has been doing [url=http://www.top500.org/stats/list/29/osfam/]pretty well[/url] in that arena for a long time. |
| | First they laugh at us. Then they ignore us. Then they fight us. Then we win.  |
| | The furthest away wine can be is "sudo apt-get install wine". I just think that Mark Shuttleworth doesn't want people to buy a Dell/Ubuntu machine expecting all their Windows apps to work flawlessly; hopefully this will make people seek out a open alternative - usually there are a few options. |
| | I think Dell shipping machines with Feisty pre-installed will have a relatively small impact on both Red Hat and Novell who aim more at medium-large businesses. I just hope that Dell's customised Ubuntu will make it easier for the end user by coming with Flash and most commonly used codecs … |
| | Redhat have contributed more code than any other company to the Linux Kernel. They have made massive contributions to Gnome, GCC, GLIBC, SELinux, ext3. They may have some closed source stuff (I'm not too sure about what or how much) but in comparison to other 'OS friendly' companies they have …  |
| | I think you slightly misunderstood the press release. Gutsy Gibbon will come with some binary firmware, drivers etc. A new official 'varient' of ubuntu will be introduced that will contain none of the above. [url=http://en.wikipedia.org/wiki/Gnewsense]Something similar[/url] already exists; afaik the Gnewsense developers will assist with the new Ubuntu varient. |
| | It will sell like hotcakes simply because Apple are so popular at the moment. [url=http://apple.slashdot.org/article.pl?sid=01/10/23/1816257&tid=107]This [/url] is the thread on /. when the oringinal iPod came out. FTA: "At an invitation only event Apple has released their new MP3 player called the iPod. iPod is the size of a deck … |
| | I think that the most difficult aspect of Linux to most people is the install. Once its on (and all the hardware is working) doing most day to day things really aren't that hard. Even installing software is a breeze with tools like [url=http://polishlinux.org/reviews/gnome-app-install/gnome-app-install.png]Ubuntu's add/remove applications thing[/url] (which I think … |
| | Its not like Apple haven't had chance to test it out; the beta has been out for years. The question is, who will the average Joe who upgrades blame? Apple who left everything the same or Microsoft who made drastic changes? Give it a couple of months and Steve Jobs …  |
| | That is just Gnome with a customised menu icon and wallpaper. If google do release an OS it would make most sense to customise a *NIX as most of the groundwork has been done. The best reason to choose Ubuntu over say Debian (or FC, SuSE, Sabayon etc) is that … |
| | I bought my brother a Wii for Christmas (was in Curry's when a shipment came in 3 days before Christmas). Wii sports, while not being full on working out, definately can get you in to a sweat, espeically in a close game of tennis. I think that if people want … |
| | iPhone or gf? iPhone or gf? hmmmmmmmmmmm.. its a tough one. In the end though I'd have to go with my gf because she is the bringer of sandwiches. |
| | The trademarked iPhone is older than any of Apple's i* products so I don't see how Apple can countersue. Apple knew that the iPhone would make a massive splash and it did and now everyone will associate the iPhone with one thing, Apple's iPhone. The only reason Cisco/Linksys's device made … |
 | Your reasons are stupid. "I'll stop using ubuntu cos there are too many Digg headlines about it! oh noes!". Use the best tool for the job at hand and stop moaning about what other people are saying/doing. If this was Digg I'd bury you  |
| | |
| | The people who are usually up in arms about stuff like this aren't usually gamers, they don't understand that if games blur reality and fantasy for some people it is the person's fault not the fault of the publisher/developer. I commend rockstar for having a go at making an original … |
| | I agree that some people may have downloaded it many times. Since phoenix I must have about 20 times from various places and on various machines/installs. However, the downloads/users ratio can be skewed the other way too. For example I have a copy of firefox on my pen drive, every … |
| | Microsoft's hardware track record has generally been good. The problem with trying to muscle in on the iPod's territory though is that an iPod isn't just a music player, to the unwashed masses its the only music player. Its a symbol. They are incredibly easy to use compared to other … |
| | A step in the right direction I believe. All we need then is AOL to see the light and allow their products (AIM and ICQ) to 'talk' and people will be able to choose what protocol/client they use on the merits of the service and software and not just on … |
| | The fight is not lost yet. The weakness in Blue Frog's grand scheme was the fact that it relied on central servers. A p2p approach would give the spammers no main target. [url=http://wiki.okopipi.org/wiki/Main_Page]Okopipi[/url] is just that. Maybe it will continue where Blue Frog left off |
| | 2.6 brought a LOT to the table and development has been going at a fast rate. I think if the core development team felt that there were too many bugs, and the rate of new critical bugs was higher than the critical bug-fix rate, they would freeze new features and … |
| | Surely Blue Frog's methodology could be altered slightly so as not to rely on central servers? A peer-to-peer approach would surely work here. With no central targets it would be a lot more difficult for spammers to bring it down. |
| | [QUOTE=drjay1627;883731]What are names starting with the ":", are they variables, constants or something else? drjay[/QUOTE] In ruby if you don't know what class an object is you can use it's class method and the docs to find out. [code=ruby] % irb --simple-prompt >> a = :something => :something >> a.class … |
| | [QUOTE=iamthwee;358343]Is there a similar such thing in linux. I.e a batch file?[/QUOTE] Of couse there is :) And its massively more powerful than batch scripting. I think this link/tutorial should be of use to get you started. [url]http://www.freeos.com/guides/lsst/ch02.html[/url]  |
 | |
| | [QUOTE=IrfanMulla;286352]What entities would you have for A car hire firm and their attributes.[/QUOTE] cars and stuff hope this helps |
| | [QUOTE=christineebrown;251613]My brother who lives in France and I are trying to communicate by webcam. We both have MSN messenger. We both use the built in mikes on our cameras. The problem is that I can always hear him but he can't always hear me. We started doing this about a … |
 | Re: Favorite Distro 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). |
| | I think you should look at the [url=http://dev.mysql.com/doc/refman/5.1/en/load-data.html]LOAD DATA INFILE[/url] docs and cron a script to import for you |
| | [QUOTE=Xessa;884086]I want to get the row number of a specific row in the table. Also is this legal? [code] INSERT INTO (SELECT * FROM myTable WHERE mynumber=2) VALUES ........ [/code][/QUOTE] Getting the row number depends on the DB you're using; Oracle supports this (via [icode]ROWNUM[/icode]) but MySQL for example does … |
| | Re: query help I think a self join is required: [code=sql] select distinct d1.id from dtlstbl as d1 inner join dtlstbl as d2 on d1.id = d2.id and d2.refid = 2 where d1.refid = 1; [/code] [QUOTE=ProfessorPC;879086]there may be another way but off the top of my head you can use "or" [code=sql] … |
 | Not really sure what you're asking. What column type is sales_categories? Also your SQL is confusing; try aliasing the table names and aligning it: [code=sql] SELECT pd.products_name, pd.products_description, pd.products_id, p.products_image, p.products_price_sorter FROM products_description as pd INNER JOIN products AS p ON pd.products_id = p.products_id INNER JOIN salemaker_sales AS ss ON … |
| | Re: SQL Help!!! You seem to be getting mixed up with your joins. You need to do an inner join to get the winning bids. I'd create this as a view: I just typed this from memory so sorry about the table/column names :P [code=sql] create view winning bids as select b1.* from … |
| | [QUOTE=realestninja]Hello I wanted to compete with myspace.com because they are monopolizing the computing industry, and I am indeed jealous. I wanted to know if anyone here knows a lot about database programming, and can help me learn how to program something that has the looks and feels of myspace in …  |
| | Re: 3D shopping [QUOTE=Phaelax;310783]The only 3D I ever thought was a nice feature for websites was for real-estate; virtual tours through homes. A 3D store sounds like something I probably would've used VRML for. Does anyone even use vrml anymore?[/QUOTE] Now the 3d buzz is around Second Life. This sounds like something someone … |
| | [QUOTE=pasabeer;366105]Is it possible to create dynamic menu items for a web application. While clicking on one menu item, it should expand and show the child menu items. While clicking again it should collapse the menu and hide the children. While clicking on child menu item, it should show the corresponding … |
The End.