genevish

Assuming the status column is the active flag you need, just change the last query to be: [CODE=SQL]SELECT * FROM TABLE1 WHERE status = 1[/CODE]

It's a simple script, giving me an error. I'm running it from a command line: scott$ python VerifyAboutPage.py chrome any And the error is: AttributeError: 'module' object has no attribute 'chrome' The relevant portions of the script should be: from selenium import webdriver import unittest, time, re, reporting, sys class …

In wxPython you can do: import wx app = wx.PySimpleApp() dlg = wx.TextEntryDialog(None, 'This is the text', 'This is the title', '') if dlg.ShowModal() == wx.ID_OK: val = dlg.GetValue() dlg.Destroy() print "You entered %s" % val

Where are you calling the getAlerte method?

I created a JTree from an XML file like this: //Load Tree from XML file File stocks = new File("//Users/scott/Desktop/saSample.xml"); DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance(); DocumentBuilder dBuilder = dbFactory.newDocumentBuilder(); doc = dBuilder.parse(stocks); doc.getDocumentElement().normalize(); // Set root folder DefaultMutableTreeNode rootnode = new DefaultMutableTreeNode(doc.getDocumentElement().getAttribute("saName")); DefaultTreeModel treeModel = new DefaultTreeModel(rootnode); objMgrTree.setModel(treeModel); // Set Pages …

I posted a link to my personal website on Facebook. When I click the link to verify it works, I get a message from Safari saying the site I'm trying to visit may be hosting malware. The site it refers to is search-box.in, which is NOT my site. Does anyone …

[QUOTE]I posted a link to my personal website on Facebook. When I click the link to verify it works, I get a message from Safari saying the site I'm trying to visit may be hosting malware. The site it refers to is search-box.in, which is NOT my site. Does anyone …

This will get you the top result: [CODE=sql]SELECT max(mark), examid, name FROM tblresults r join tblstudents s on r.studentid = s.studentid group by examid[/CODE]

Post your code...

An easier query would be: [CODE=SQL]select * from table where column not in (1, 4)[/CODE]

I like Mac the Ripper and Popcorn myself...

Omit the WHERE clause

Post what you've done and we can assist.

"long" is a keyword. Escaping it with the back tick fixed your error.

Try this: [url]http://www.clamxav.com/[/url]

Try this: [CODE] //rs is the resultset ArrayList ar=new ArrayList(); while(rs.next()) { String strprodvalue = rs.getString("prodvalue"); out.println(strprodvalue); ar.add(strprodvalue); } [/CODE] ar is an ArrayList that has all of the values. Note that you don't need to know how many values there are ahead of time.

What backend language are you using? ASP? PHP?

This may help: [url]https://support.mozilla.com/en-US/forum/1/337371[/url]

Are you trying to pass data across pages, or within functions on the same page?

Which part are you having trouble with? Are you getting the checkbox values? Do you need help with the SQL? Note that you only need one query. Something like: [CODE=SQL]select * from table where column = value1 or column = value2 or column = value3[/CODE]

Add these at the beginning of the page: [CODE=HTML]<META HTTP-EQUIV="Pragma" CONTENT="no-cache"> <META HTTP-EQUIV="Expires" CONTENT="-1">[/CODE]

[CODE=PHP]<?php $pattern = "{\/\>}"; $replace = " onclick=\"alert('a variable name from php')\"/>"; $string = "<use xlink:href='#gpPt4' transform='translate(261.7,184.3) scale(4.50)'/>"; $newstring = preg_replace($pattern, $replace, $string); echo $newstring; ?>[/CODE]

$_GET['id'] will get the variable from the URL. And yes, that will still work when you have the globals enabled.

Lots of good examples out there: [url]http://www.w3schools.com/ajax/ajax_intro.asp[/url] [url]http://daniel.lorch.cc/docs/ajax_simple/[/url] Basically you'll have a page that returns the list of provinces based on a passed in parameter. Your main form will have an onChange Javascript event attached to the country selector that calls this page to populate your provinces selector. Try out …

Select * from teams t join fixtures_results f on t.team = f.team and t.round = f.round

I'll assume you are using sessions to track your login across pages. Set a session variable called "LastAction" as a timestamp. If the user visits a page, check to see if the LastAction timestamp is less than 5 minutes ago. If so, update it to the current timestamp. If not, …

Looks like your PHP install does not have the Mysql libraries installed/loaded.

You can't cast to Jan. Jan isn't a datatype. Is campaignmonth an integer and you want it to be a string? Use a case statement.

Hehe, never liked the Start button myself. "How do I shut down?" "Go to the Start menu..." Huh? :-) Things are a little different on a Mac, but you'll figure it out quick. If you have an Apple store nearby, spend some time with them and they can teach you …

I have started using Eclipse for PHP development and like it a lot, once I got used to the quirks of it (as any IDE will have).

The PHP code is parsed on the server and only sends the output to the browser, not the whole piece of code (unlike JavaScript which is parsed by the client).

Check the comments here: [url]http://php.net/manual/en/function.is-dir.php[/url]

[QUOTE=mohit007kumar00;1196387]what is trigger in the database envoirnment ?[/QUOTE] [url]http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=what+is+trigger+in+the+database+envoirnment+%3F[/url] [QUOTE]how many types of trigger is there ?[/QUOTE] [url]http://www.google.com/search?hl=en&q=how+many+types+of+trigger+is+there&btnG=Search&aq=f&aqi=&aql=&oq=&gs_rfai=[/url]

[QUOTE=Silvershaft;1193598]Hey guys! I want to make a simple login system with PHP, I am pretty noob with php, but have done C++ for like year so understanding the code shouldn't be a problem. Things are done a bit different in the web than in simple program so.. I found this …

Add this to the page you are redirecting from: <meta http-equiv="REFRESH" content="0;url=http://www.the-domain-you-want-to- redirect-to.com">

You're missing the period after the $find variable

So what's the question?

if (preg_match ("/^ /" , $text entry) == 0) { echo "You only entered spaces!"; }

You may be able to do a single query using OR in the where clause, and DISTINCT in the SELECT clause. For example: [CODE=SQL] SELECT DISTINCT comment_id, comment_title, comment_description FROM comments WHERE comment_description LIKE '%Hello World%' OR comment_description LIKE '%Hello%' OR comment_description LIKE '%World%' [/CODE]

Try this: [CODE=PHP] /* ==== Code to create hit_counter database if it does not already exist ==== */ $DBName = "jobinterview"; $SQLstring = "CREATE DATABASE IF NT EXISTS $DBName"; $QueryResult = @mysqli_query($DBConnect, $SQLstring) OR die("<p>Unable to execute the query.</p>" . "<p>Error code " . mysqli_errno($DBConnect) . ": " . mysqli_error($DBConnect)) …

[QUOTE=nschessnerd;1192477]Hi, I have a query: [CODE=sql]SELECT h.id, h.creator uid, h.haiku, h.title, h.likes, h.approved, cat.name category, count(c.id) comms, h.anonymous, CASE h.anonymous WHEN 1 THEN 'Anonymous' ELSE u.username END username FROM haiku h left join categories cat on cat.id= h.category left join comments c on c.haiku=h.id left join users u on u.id=h.creator …

[QUOTE=upload12300;1192379]i have one table, which has three fields and data. Name , Top , total cat 1 10 dog 2 7 cat 3 20 hourse 4 4 cat 5 10 Dog 6 9 i want to select record which has highest value of "total" for each Name so my result …

There's something wrong with the $odbc link identifier. Please show the section where you have defined that.

[CODE=PHP] $select = ("SELECT DATE_FORMAT(%c-%d-%y) as theDate, * FROM photo_albums ORDER BY uptime DESC LIMIT 5 "); $result = mysql_query($select) or die(mysql_error()); while($row = mysql_fetch_array($result)) { echo "<li>" ."<p align='left'><a href='viewAlbum.php?aid=".$row['aid']."'>" ."<img src='".$row['filepath'].$row['filename']."' width='75px' align='left' border='1'/></a>" ."<span class='lpBold'>". $row['theDate'] ."</span><br/>" ."<a href='viewAlbum.php?aid=".$row['aid']."'>".$row['description']."</a></p>" ."</li><hr width='75%' color='#FFFFFF' />"; } [/CODE]

He must have copy and pasted wrong. It works...

[QUOTE=niranga;1187475]Hi, So Sorry for taking so much time to reply. [B]$_SERVER['DOCUMENT_ROOT'] [/B]gives me this [B]/home/users/web/b562/whl.aunn2008/project1/www/[/B] So as the FTP client displays the folder structure the image should be placed in [B]/home/users/web/b562/whl.aunn2008/project1/resources/additional/image.jpg[/B] Still [B]../resources/additional/image.jpg[/B] does not displays the image :( :( :( Niranga[/QUOTE] OK, by what you've said, the webserver is …

Well, it appears the path you have is wrong. You need the path as the webserver sees it, not as the OS sees it. So this: $image_path = 'C:/wamp/www/Playhill/images/'; Should probably be this: $image_path = '/Playhill/images/';

Well, line 2 should be eliminated...

Im a little confused on the scenario, but maybe this will get you close? [code]BEFORE INSERT SET NEW.calling_num = (SELECT CASE users_name WHEN '' THEN NEW.calling_num ELSE extension_number FROM cdr_phone_system_data WHERE extension_number = NEW.calling_num);[/code]