[query] Forum Topics

I have an application that uses an *.accdb file as the back-end database. Connecting to and retrieving data from the access file is not an issue and is working quite well. However, as a precaution, I have the application first check to make sure the database file exists in the …

Really I am a PHP beginner, I am working on this code and I need help, kinda stuck. I have a database with 3 fields(id, date and venue). This is simply what I want to do; I want my script to go into the database fetch the date and compare …

Hallo guys, a theoretical question I have there for you. I have a search form in HTML with several input fields, so the user can search for particular features in a db. My queiston: How can I generate a dynamic query, depending on which fields the user had filled in? …

Hi all, I have a pagination script that works great apart from one last thing I require some pointers on please. The help i need is with the SELECT query - currently the select query works, but i am bringing back all records, I am trying to bring only certain …

Hi, this is my query [CODE]$result = mysql_query("SELECT SUM(`qty`) FROM sims_ac WHERE region ='North'");[/CODE] How I can show this [CODE]$result[0][/CODE] without using While loop or any other loop.

Hi there. Okay heres the scenario. I have 2 tables "Logins" and "User_Details" What I want to do is write a PHP query that whenever a new user is created, that is manually entered into "User_details" table using a form, the next thing that should happen is that it should …

Hi there, I’m very new to ColdFusion and I’m still going through the learning process. I have a report to create in CF and I don’t know how to start: I have three tables in 2 databases: tblEmployeID with EMPLOYEEID, EMPNAME, MGRName (this is in SQL 2000) tblCategories with CODEID, …

[code] try Dim da As String = "+100acs+" Dim con As SqlConnection = New SqlConnection("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts; Integrated Security =True") Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("Insert into sales_details (bill_number,product_id,quantity,rate,amount) VALUES ('" + da + " ','" + Ddpproducts.SelectedItem.ToString + " ','" + Textquant.Text + "','" + Ddpproducts.SelectedValue + "','" …

Hy, I seek your help in solving the following problem: I have a select which returns columns like ( without count_same which I need to create by counting the same name): ID | NAME | no_items | count_same ----------------------------------------------------------- 1 | A | 1 | 2 2 | A | …

[B]Hello everybody, hello Dani:icon_cool:![/B] I'm doing my homework of 'Data Base', exactly in the chapter: Relational Algebra, here I am, I can't find a specific relation (or the SQL corresponding query) :icon_confused:! Here the schema: [COLOR="Green"]MEAL(guest,date); MENU(dish,date); PREFERENCE(person,dish);[/COLOR] I wanna find the SQL query (or the relation in Relational Algebra):[COLOR="Green"]"the …

hi - i have coded a seacrch box and its results are displayed in a tabular form. i have also a print button which when pressed shud create a pdf based on that table that is displayed. for this i have a separate page called pdf.php. i am using ezpdf …

hi all im looking to use a select mysql query - but im trying to query the database against a users logged in sessions. I have the sessions working correctly but I am unsure how to included the session data in my sql select query. here is my users session …

Hi there, I am making (more like, have already made) an IRC bot in Java. I would like to be able to query a shoutcast server with my bot and return basic information (such as now playing, bitrate, etc). I have scoured google and only found php code which i …

Does anybody have any ideas of how to make an advanced search function? I would like to accept a string as the search query. i want it to run a query on the string as a whole, and for each word in the query. The problem is here: The results …

Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 …

Hi, I’m going to calculate a ratio between two entities but are having some trouble with the query. The principal is the same to, say a forum, where you say: A user gets points for every new thread. Then, calculate the ratio of points for the number of threads. Example: …

hi i want to insert a textbox value into one column of a table. bt wht i m getting error as: Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '{'. the code is [CODE]SqlCommand comm = new SqlCommand("insert into Sample {'email_id'} values("+ TextBox1.Text+")", conn);[/CODE] how should i do it if i dont …

Dear all, I am very new at SQL programming and are using the Microsoft Query to avoid alot of SQL programming, but I am stuck on one thing when I try to filter some data from the database... I want to show all delayed deliveries to our customers... Our Policy …

Hi everyone, I'm currently working on a assignment and have to write a short (max 3 lines) definition on some different kinds of queries. I've written a definition to all of them but I'm having a really hard time about one particular query: Scan Query. I've tried to look in …

Hi everyone, I’m having some difficulties with a query which purpose is to give users with more than one thread (called CS) in current year a 5% point “raise”. My relational schema looks like this: Thread = ([B]threadid[/B], threadname, threadLocation) threadoffering = (threadid, season, year, user) user = ([B]name[/B], points) …

OK I'm not really sure how to put it but I will try my best to explain my question. Basically I am really lost when it comes to arrays and for loops, so I need help badly. I have in my HTML Form about 20 checkboxes like this: [CODE]echo "<input …

So here is my search query set [CODE]/all possible input combinations //name and id combinations if($q != '') { if($id != '') { $sql = "select * from course_participant where name LIKE '%$q%' and nic='$id'"; $result = mysql_query($sql); $num_rows= mysql_num_rows($result); }else{ $sql = "select * from course_participant where name LIKE …

I have a database I am creating with about 50 users over a network. There are about 6 groups of users and these users are spread across 10 branches. I want to block/allow users from particular forms and views. For example I want branch users forms to be filtered by …

Hi, I am looking for the best solution to my situation: - I have businesses listed in a MySQL table. - Each business can bid on up to 10 keywords (different prices for different keywords). A user inputs a keyword and then I must find a way to query my …

Running a SQL query from the following code: [CODE] <php if(sizeof($_POST['addcandidate'])){ foreach($_POST['addcandidate'] as $id){ $name= mysql_query("SELECT LastName FROM candidate WHERE Candidate_ID= '$id'"); while($rowz= mysql_fetch_assoc($name)){ $candidatename= $rowz['LastName']; $alter= "ALTER TABLE '$votertable' ADD '$candidatename' int"; mysql_query($alter) or die(mysql_error()); } } } ?> [/CODE] I return Im getting: [COLOR="Red"]#1064 - You have an …

Hi. I have the next problem: 1. I'm doing a select in a DB table and I'm displaying the result on a page 2. because one of this field is a comment and is too long, I display only the beginning of this folowed by "Read all" as a link. …

[CODE] int[][] jaggedArray = (from line in File.ReadAllLines(fileName).Skip(1) select (from item in line.Split('\t').Skip(1) select int.Parse(item)).ToArray()).ToArray(); [/CODE] This is a crazy example. It was sparked by what is probably a homework thread on another forum here, but it is basically reading in a tab-delimitted text file, stripping out the first row …

[code] Dim da2 As OleDb.OleDbDataAdapter Dim cols As Integer = Attendance_QueryDataGridView.ColumnCount Dim rows As Integer = Attendance_QueryDataGridView.Rows.Count Dim a(cols) As String Dim dt As New DataTable("Attendance") da2 = New OleDb.OleDbDataAdapter(sql, con) da2.Fill(ProjectDataSet, "Attendance") Dim NewRow As DataRow NewRow = ProjectDataSet.Tables("Attendance").NewRow For z = 0 To cols - 1 a(z) = …

Just when I thought I was comfortable with SQL queries, another one popped up that I can't get around with.... I'm ALMOST there but not quite. Here is the situation... I'm dealing with two tables [B]PoolTeams[/B] and [B]PlayerStats[/B] The PoolTeams table has two columns: [B]PoolTeamID[/B] and [B]TeamName[/B] The PlayerStats table …

Anybody know how to do the following: id (PK/autoincrement) file_id (FK/int) - same file id pops up loads of times statement (varchar) - just some text from the file status (tinyint 0/1/2) - depending on the statement = 0 or 1 or 2 into a single record for each file_id, …