1,073 Posted Topics
 | Hello, I can see a couple of ways to do this but some questions first. Does a ticket always have an entry in the ticket_history table? In your description of the output you reference the status three times. Twice from ticket_history and once from ticket. Is that required? Is this … |
 |  |
| | Hello, What you need to do is get rid of the variables. [CODE]SELECT VendorId From Vendors WHERE CountryId in (223, 245, 285, 286) ORDERBY CreatedDate'[/CODE] |
 | Hello, From what I see in the documentation you can treat the GROUP_CONCAT(itemname) as a list to test against. [CODE] select ContainerName, ContentType, and GROUP_CONCAT(ItemName) as itemnamelist where "Apple" in GROUP_CONCAT(ItemName) group by ContainerName [/CODE] At least that is the way I read it. I would like to know if … |
| | Hello, One way to do it is to make the output column names the same in both queries and then use UNION to combine the two: (Select xxxx as Field1, yyy as field2 .... ) UNION (Select zzz as Field1, ttt as field2 .... )  |
| | You need to see if the site is setup in Plesk properly and find out where httpd is looking. If it is Linux server for both old and new then files should have the same permissions on old and new. Try httpd -V from a command prompt to see where … |
| | Re: php grab 3rd wed Hello, The first thing I can think of is that the date of the month must be greater than the 14th and less than the 22nd (ie 15th through the 21st ). then just test for weekday being wed. |
| | Hello, For one thing you need spaces after the commas in you select: select Emp_Id, First_Name, Last_Name, Gender, Mobile_No, Email_Id, Blood_Group from Employee where |
| | A couple of things seem a bit odd to me. Your specs say you have 16 processors but only 512MB memory and 30GB hard drive space. There may be 16 processors in the server but you are not being allocated all 16. And 512MB of memory is a bit low … |
| | Hello, If you put your code to get the first result in place of temptable in the code below it should give what you are looking for. (I think) [CODE]Select ProdID, (Max(Price) - Max(Amount) ) as NewAmount from temptable where TotQuantity >= BreakLevel Group By ProdID [/CODE] Let me know … |
| | Hello You need spaces to separate the variable from the test: [CODE]//Skjekk passord if ($password != $password_db) echo "incorrect password"; else[/CODE] |
| | Try this and see how it works: SELECT article.article_title, article.article.body, count(*), sum(comments.status) from articles, comments where articles.ID = comments.Article_ID group by article.article_title Should be about right. |
| | Re: Join two queries The trick is to get the basic query with all of the correct data showing first then add in the SUM options afterward. Try this: [CODE] SELECT id.RouteNo, id.PickVol AS total_volume, b.volume AS rested_volume FROM imported_data id LEFT JOIN buff b ON id.RouteNo = b.route AND WHERE id.id_date = '2010-10-10' … |
| | Re: UNIX Hello, Instead of ftp use scp (secure copy) or rcp(remoter copy). To copy file1 from myserver in /home/me to newserver1 in /tmp you would enter: scp /home/me/file1 newserver1:/tmp System would prompt for your password in scp if you have not configured ssh keys. If the servers are close together you … |
| | Hello, The only thing I have ever notice is that when you query a view from another view is that it can be slower if the first view creates a large amount of output. You might want to simply add the query as an outer select to the syntax for … |
| | I am not sure but I believe you have the syntax for include wrong. It should look something like this: <?php include "../config.php" ?> and this would imply that config.php is one directory up from the file calling it or in your case: /home/glbo123/public_html/ If it is in the same … |
 | I believe you will find it is: ipconfig /renew |
| | |
| | I think what you are looking for is grep (get regular expression) it is used to pull specific lines from a file. you could then use awk to strip out the fields you want. It really depends on the format of the actual file in question. The page you directed … |
| | |
| | Re: Runas in bat Hello, You can run a login script for a specific user by adding it to their profile. Go to Control Panel, Administrative tools, Local Users and Groups, Users. Then right click on the user and select Properties and then the Profile tab. |
| | Re: Question The images are stored on a server at craigs list and only their servers can access the images to display them on the ads. |
| | Hello, SUDO is to make you have root privileges for executing the script you are about to run not really used for switching to a different user. There are other options. Linux allows you to set up a script so that when it is run it appears to be run …  |
| | You would run into a lot of issues with authenticating as a valid email server for the domain you are trying to send as. I know my email servers would reject your messages as being bogus spam due to your server not being a valid server for that domain. You …  |
 | Hello, Here is something from the reference I use: [CODE]<p> Search the online resources database:<br /> <form action="fulltextsearch.php" method="post"> Keywords:<br /> <input type="text" name="keywords" size="20" maxlength="40" value="" /><br /> <input type="submit" value="Search!" /> </form> </p> <?php // If the form has been submitted with supplied keywords if (isset($_POST['keywords'])) { // … |
| | Well to begin with your CMOS battery is dead and needs to be replaced. When you turn your computer off does it still have access to power (i.e. plugged into the wall and powered off with the front panel power switch) or do you turn off the power strip it … |
| | Down load the UBCD from [URL="http://www.ultimatebootcd.com/"]http://www.ultimatebootcd.com/[/URL] It is a linux boot disk with several utilities on in including repartitioning, imaging or copying your hard disk. Also available is a version for windows but you hve to use your working windows system to create the cd Image. [URL="http://www.ubcd4win.com/howto.htm"]http://www.ubcd4win.com/howto.htm[/URL] |
| | It could be your internal firewall or your ISP blocking port 25. Try this from a command prompt and see what you get: telnet <email server name> 25 If you get a HELO back you are connected to the pop server. IF not check your firewall and see if port … |
| | It could be something as simple as part of the RAM being used for Video memory. I would check the BIOS and see what it shows instralled. |
| | Re: Sql select It might be easier to use this sort them with the highest contact number and then just get one record. [CODE]SELECT contacts.forenames, contacts.surname, communications.number, contacts.contact_number FROM contacts LEFT JOIN communications ON contacts.contact_number=communications.contact_number WHERE contacts.surname='$sn' AND contacts.forenames='$fn' AND communications.number='$em' ORDER BY contacts.contact_number DESC LIMIT 1 [/CODE] |
| | Re: shockwave-flash I believe there are different versions of shockwave for IE and FF. Check to see if you have the IE plugin. |
| | Your nameservers are not responding to requests: nslookup altprices.com ns1.altprice.com ;; connection timed out; no servers could be reached The name servers are set to: [rod@lptp1 ~]$ nslookup ns1.altprice.com Server: 192.168.15.1 Address: 192.168.15.1#53 Non-authoritative answer: Name: ns1.altprice.com Address: 204.236.219.103 but I cannot ping them... rod@lptp1 ~]$ ping 204.236.219.103 PING 204.236.219.103 … |
| | Re: MySql Error Looks like you missed the $ in front of value1 [CODE] $sql="INSERT INTO finaltable (value0, value1, value2) VALUES ('$value0',[COLOR="Red"]'value1'[/COLOR],'$value2')"; [/CODE] |
| | Re: my sql database I believe you need an ODBC connection (available from mysql) to the MySQL server in order to make the connection. |
| | try using this: [CODE]select DISTINCT productID, regionID min(price) as MINP from sales_db where available_volume>5 group by productID, regionID order by min(price) desc[/CODE] |
| | Hello, The problem is you are missing the ON that tells the join how to connect the two tables. There has to be a reference field in employees to link it to job titles but your query will look something like this. [CODE] use Dwight_wk2 Select * from employees Left … |
| | Hello, Off the top of my head how about if you sum the availability status and select only those where the sum is 0. |
| | I also have moved off of Windows on my laptop and my main desktop is not far behind. For anything that I want to run as if I have Microsoft's continually hacked and patched Windows I use WINE which works even for my games (World of Warcraft, Starcraft, Red alert … |
| | I would run malwarebytes (download from cnet's download.com) and see if anything has got onto your system. Then take a look in task manager at the processes tab to see processes that are running and sort them by the CPU time(click the CPU heading twice) to see what is taking … |
| | Hello, I have put a few of these together in the past and the best way I have found is to include a reference to the parent sales person in the sales person record. Something like Person_ID Parent_ID First_Name Last_Name ... |
| | OK quick question... which field holds the rank the user gave the song? |
| | Communications speeds when transferring data are usually, but not always, measured in bits per second. A bit is a binary or logical 1 or 0. Data transfer speeds when transferring data, etc. in a computer, such as between memory and a hard disk drive, are often, but not always, measured … |
| | Hello, If your system is running linux you can install lynx which is a text based web browser. |
| | When I have seen this in the ast it has been due to not having software installed for burning DVCD's. Normally something like NERO or Sonic. |
| | Hello, Can you ping the site from a command prompt? and try nslookup to see if you are able to resolve the domain name. nslookup [url]www.example.com[/url] |
| | Hello, You have a bad memory chip. What is happening is it is in the upper memory and you are not using that register till after you have been running a bit. |
| | find /var/log -mtime 30 -print -mtime n File’s data was last modified n*24 hours ago. or ls -R /var/log | grep Mar However it really depends on what your logrotate configuration is set for. You may not be saving that far back. ls -la /etc/logrotate.d will give you what is … |
| | Hello, several options. 1. Export to excel then save as a .CSV file and import to MySQL. 2. Find a copy with the hack of Access2MySQLSync and it will do the work for you. 3. export to a tab delimited file and import. |
 | |
| | Your missing the second l in null 'email' varchar(100) NOT NUL, |
The End.