6,934 Topics
 | |
| | ok so , i have a sql query puzzles . say that i have a table "PERSON" with the data look sumthing like this: PERSON Name ID ----------------------- John 12123 Kimberly 33311 Leo 87892 And i have a table score that look sumthing like this: SCORE ID MARKS ------------------------ 12123 …  |
| | Hi there, I'm dynamically pulling my sidebar image from a database, the image is resized to fit based on which dimension is smaller. Then I'm using a jquery script to reposition the image so that any overflow on the width overflows both sides rather than just on the right using … |
| | Hi All, I sware I am loosing the will to live, I have tried to accomplish this by my-self for about 2 weeks now and I am still at square one, I prey someone can help me. I am writing an application for booking conference rooms and I need a … |
| | Can anyone please help me with this one? i have successfully save data in my form but i can only do it in a single row.. please help me how to add rows automatically, how to auto number the Item No., how to auto-total the Quantity column and the Unit … |
 | when i submitted the form i get this error on my site but i am sure of the config You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 <?php mysql_connect('localhost','ali_root','kingstone2012')or … |
| | Hi, I am writing a little app that will have a rich text box that users will be able to write SQL statements and save them to SQL Server table. I would like to validate the SQL statement before saving the string. Because another process picks up the string and …  |
 | $plugins = $Server->Get('plugins'); echo "<br /><br /><b>Plugins</b><br> "; foreach($plugins as $plugin) { echo $plugin."<br>"; } That snippet above spits out a long list of plugins from a server. How can I store each plugin listed into SQL so that its stored as '$plugin[0]<br/>$plugin[1]<br/>$plugin[2]<br/>' and so on so that when I … |
 | What's sql syntax to change database name ? I tried this: ALTER DATABASE name RENAME TO new_name It doesn't work. |
 | I am using LINQ in my project. I have tried using update query. But this is not working for me. Please any body help me. Did I need to change any settings of my database? or for the datacontext? My code is as follows: here dc is the datacontext, getinteger() … |
| | How to call Sql 2000 Stored Procedure from vb6 which take 2 input parameter  |
 | Hello, I am interested in getting sql language certification. I have some knowledge and would want to know how much I have to learn more to pass the exam. Also which site to use for passing, so it would be worth spent money, so my resume would look better? I … |
| | Hello, I am trying to import mysql backup from the old computer to the new computer and these error appears: Pencarian SQL: -- -------------------------------------------------------- -- -- Table structure for table `nafqc_usergroups` -- CREATE TABLE IF NOT EXISTS `nafqc_usergroups` ( `id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', …  |
| | Hello, I am trying to import mysql backup from the old computer to the new computer and these error appears: Pencarian SQL: -- -------------------------------------------------------- -- -- Table structure for table `nafqc_usergroups` -- CREATE TABLE IF NOT EXISTS `nafqc_usergroups` ( `id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', …  |
| | Hi all, ive got a big question about conducting mysql_queries.. i have a schedule program that needs to sort through and pick the records that apply.. the date will change, and used a php date() formatted to mysql date and pick out the ones records that are active vers inactive. … |
| | I'm learning as I go here, but I'm stuck at the moment. I am trying to dynamically create a datagridview and populate it from a database using SQL. I have created my columns, but I don't know how to assign the data coming out of my sql query to its … |
| | In my program, I have a section to insert information about a customer into an Access database. I get the error below at the .ExecuteNonQuery. Message: System.Data.OleDb.OleDbException (0x80004005): Field 'Customer.Business_Phone' cannot be a zero-length string. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& … |
| | Hi all, Anyone know how to create a data base gives the name of the same parameterized? Example in a store procedure, named 'x', which has a parameter, this will do since the create dabase @variable create procedure creadatabase @db_name varchar (10) as create database @db_name go But this variable …  |
| | Help me in constructing a MySql Query to retrieve the rows based on datetime column. Below are the conditions: 1)The date difference between today and date in that column sholud be =>2 days. 2)If the day of the date in DB column is Thursday/ Friday then the date difference between …  |
| | how to convert vb.net and sql server 2005 into .exe file the exe file can be run in the another system but it cannot be save the data. the connection string can be errored because my computer name and another computer name is different . how to solve this problem. … |
| | I have created a cube in visual studio, when i want to deploy it i get the following error: Error : The project could not be deployed to the 'USER-PC\SQLEXPRESSR2' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service … |
 | Hello i have a database table | col1 | col2 | col3 | col4 | col5 | | val | val | val | val | val | | val | val | val | val | val | | val | val | val | val | val | … |
 | Hello, i got this error when i click my button save. Error: .Net SqlClient Data Provider: Conversion failed when converting datetime from character string. please help me... this is my save button code: Private Sub btnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim check As Integer Dim … |
| | Hi all, In the program I'm working on, I am making a form that submits data to an Access 2007 database. I can connect to the database fine and run a select query, but when I try an insert query I get an error: "statement contains the following unknown field …  |
| | Someone told me that even the basic Oracle SQL commands are useful to learn and I can find jobs with it. I will not just learn the basic commands of course, I will do my best to learn it completely but first i need to know if its still commonly … |
 | I am working in php along with Mysql in backend, why this query is giving error : You have some problem in mysql syntax, check manual, this is that query: $Userid= $_SESSION['userid']; echo $Userid; $Dep = "select departmentName from department where userid='$Userid' "; $qry ="select registrationNo,name,fatherName,cnic,gender,discipline,department,admissionSession,email,password,address,domicile,contactNo,status,currentEmployer,designation,salaryInfo,totalExperience,lastOrganizationname,organizationAdd,organizationPhno,organizationEmail,Remarks from students where registrationNo='$RegNo' … |
| | i have made a database in sql+. it has a database. there is a table project. its columns are p_id,p_name,p_manager. i have inserted 5 rows in above table. in d front end in vb6 i have a form . please help me with the code such that my p_id is … |
| | Hello I have a table item1 | Item | Qnty | ProdSched | | a | 1 | 1 | | b | 2 | 1 | | c | 3 | 1 | | a | 4 | 2 | | b | 5 | 2 | | c … |
 | Hello I am using Apache derby embedded database: I have been using a system to display records from the database described in "DisplayInstructorAvailableNowJTable.java". it allows the result set to create a model from a prepared statement. I have only uncovered the tip of the iceberg concerning JTABLE. I am not … |
| | how do you display information dynamically? |
| | Hi, I have a problem on getting data from XML file. I am honestly have 0 knowledge on this. Here is the XML data content, i opened the XML file using notepad then pasted here. <?xml version="1.0" encoding="utf-8"?> <?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:Test-Form:-myXSD-2012-09-02T13-13-23" solutionVersion="1.0.0.55" productVersion="14.0.0.0" PIVersion="1.0.0.0" href="http://share.test.com/it/Test%20Form/Forms/template.xsn"?> <?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.3"?> <my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:pc="http://schemas.microsoft.com/office/infopath/2007/PartnerControls" … |
| | Hi All, I have intermediate knowledge in VB.Net coding. I have searched the web to find help with my issue but to no avail. I mean I can't find one that is helpful though there are some in Web based applications. I have an urgent issue where I want to … |
 | I hate to ask, but I need some help with code. I don't have any because I don't know where to begin. Here's what I'm after. I have a Sql CE database attached to the app, and a table called DUI_Cite_Numbers. There is two columns, DUI_Cite_Start and DUI_Cite_End. I need … |
| | Hi guys, I'm a student and need to practice Oracle SQL queries since we have Advance SQL in our syllabus. I have Intel-based MacBook Pro running Mac OS X Snow Leopard 10.6.8. I just downloaded the SQLDeveloper for Mac and unzipped it. The application executed and started well. But I'm … |
| | Hello, Can we perform bulk insert for SQL data? I have the complete SQL data in text files. There are multiple tables and the corresponding text files. I tried to do the bulk insert but always got some new error. Please help me to get an answer. My code Imports … |
| | Hey all, This website is a directory and the problem is authenticating users to edit a server, even after they've logged in. The idea is to stop any SQL mix-ups due to my weak code (I'm learning PHP). When they click 'Edit' next to the server after logging in they … |
| | Hey guys I have a mysql database that has an events table. The events table consists of the fields Title, Date, Place and description. I am trying to display the table on the browser using php coding. it should list important events first according to the date. so as follows …  |
| | |
| | I have 3 tables in which one column name is common for all i.e PRNO .I want to write SQL query to select everything from Table1 where PRNO is 500, Table2 where PRNO is 500 , Table3 where PRNO is 500 . “Select * from Tab1,Tab2,Tab3 WHERE PRNO=500” Getting Error … |
| | In my page, there are 3 drop down menu. Dropdown 1 : for storing car model which retrieved from CarTab in database (SQL) Dropdown 2 : for storing username Dropdown 3 : for storing plate num The function of the all drop down menu, there are related to each other. …  |
| | when i use sha 512 on password field then it says k pasword field cannot be empty but when i remove sha512 constraint then it works and with any other hash it also works why ? and plz suggest me some good secrity hash etc to apply on password field |
| | Hi I have a question, I want to transfer all nodes to a datarow Here is my XML <Employee> <person> <firstName>Jon</firstName> <lastName>Johnson</lastName> <skills>Singing</skills> <skills>Dancing</skills> </person> </Employee> THE HEADER TABLE SHOULD LOOK LIKE THIS WITH RELATION Profile_ID | Firstname | Lastname| 10 | Jon | Johnson | AND THE DETAIL TABLE … |
| | Hi there, I have Page that goes to "sub categorys", but each time I upload a new product the subcategory gets duplicated each time, instead of having one "Vintage" category as I want I have duplicates. My current SQL query string is SELECT DISTINCT Picture, SubCategory, Categorie FROM Table1 WHERE …  |
| | Please take a look at the code below. It is a copy of the coding of a function and a subroutine I've coded in my program. The SQL Database VBDB has the table Users defined so that the default access level is 0. The problem is that the access level …  |
 | I have no issues with the query in the below code. But the second code is throwing the error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Working code …  |
| | Hi, I have a dynamically generated sql query that is generated in VB6 and then passed on to SQL Server 2005. The query joins(inner join, left join, etc.) multiple tables. If I were to execute that query in Sql Server Management Studio, I would get something like this: TrayID| TrayID … |
| | Please help me. I want to set the identity specification to yes, but all the option is gray out. I could not change it to yes from no. Ĩ̷̊ñ sql server 2008. Thanks |
| | I have no issues with the query in the below code. But the second code is throwing the error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Working code … |
 | Hello hi. I am seeing flames with using FILESTREAM in SQL Server 2008! I have a table (Products), in which I wanna store a link to an image stored on disk, under the ProdPicture column. This is what the script looks like: CREATE TABLE PRODUCTS ( ProdID INT PRIMARY KEY, … |
| | I'm making a B2B portal that can see just loggedin business customers that I add to base, I finished almost all, but there is one problem. When customer add some goods to his cart, goes to checkout and confirm his order he will have a link to invoice.php?ids=156 and that … |
| | I am really in mess as I am unable to solve problem with Smarty Multi Dimension array. Below is the way I want to execute Smarty. First of all I will list all customers. Than I want list of all items purchased by that customer. I have two tables inside … |
The End.