What is wrong with this SQL statement? - KingPin's Forum
KPsDenKPsDen ArmoryImage HostingLegendz text RPGIp DisplayIRCFlash Arcade
Forum
      |        
Register
         my char is bugged (Posted By:madjestic - Replies:2 - Views:12)      « »     Ya what's open (Posted By:Bionuclear - Replies:5 - Views:70)      « »     [Check4SPAM] RE: URL Attempt (Posted By:victor2008 - Replies:0 - Views:1)      « »     [Check4SPAM] RE: URL Attempt (Posted By:victor2008 - Replies:0 - Views:1)      « »     [Check4SPAM] RE: URL Attempt (Posted By:victor2008 - Replies:0 - Views:1)      « »     Salutations (Posted By:Bionuclear - Replies:4 - Views:35)      « »     [Check4SPAM] RE: URL Attempt (Posted By:victor2008 - Replies:0 - Views:1)      « »     !!!brand new event!!! (Posted By:Bionuclear - Replies:5 - Views:87)      « »     [Check4SPAM] RE: Offer:We Offer Brand Edition Of Unlocked... (Posted By:libercom - Replies:0 - Views:1)      « »     Machinima.com Music Video (Posted By:Ego - Replies:9 - Views:110)      « »     
KingPin's Forum
 
K.P.s.N. Register vbBux / KPs Mall Bugs Blogs FAQ Search Today's Posts Mark Forums Read Donate
Go Back   KingPin's Forum > KP's Network Forum > RSS News
Reload this Page What is wrong with this SQL statement?
 


RSS News This is a discussion on What is wrong with this SQL statement? in the RSS News;
Description: <sql:query var="totalvolunteers" dataSource="${dataSource}"> SELECT COUNT(DISTINCT LOCATION) from registration <sql aram value="%${param.LOCATION}%"/> </sql:query> I want to display the total number of ...

Reply
 
LinkBack Thread Tools
What is wrong with this SQL statement?
(#1 (permalink))
Old
sassy is Offline
Private
Points: 190, Level: 2 Points: 190, Level: 2 Points: 190, Level: 2
Activity: 0% Activity: 0% Activity: 0%
sassy is an unknown quantity at this point
 
sassy
Rupees: 66.00
Bank: 500.00
Total Rupees: 566.00
 
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Join Date: Dec 2007
What is wrong with this SQL statement? - December 13th, 2007

<sql:query var="totalvolunteers" dataSource="${dataSource}">
SELECT COUNT(DISTINCT LOCATION)
from registration
<sqlaram value="%${param.LOCATION}%"/>
</sql:query>

I want to display the total number of people going to a certain location. So in my database, if there are 5 people who selected london as their location. the number 5 will be displayed on my webpage.

Please help to correct.

 
Reply With Quote
Reply

Bookmarks

Tags
sql, statement, wrong

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Rupees Per Thread View: 1.00
Rupees Per Thread: 15.00
Rupees Per Post: 5.00
Forum Jump



Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
Copyright 2004-2009 KPsN


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81