6,934 Topics
 | |
| | Hey there Im tring to insert to a database from a form , however I cant get it to insrt with the dropdwon list, any help would be loved <h1>Insert Data Into Database Using CodeIgniter</h1> <?php echo form_label('lecturer_id:'); ?> <?php echo form_error('dname'); ?> <?php echo form_input(array('id' => 'dname', 'name' => … |
| | hello everyone, I am having some difficulty setting up a connection to my database. I created one on godaddy but am unable to get past this one hump: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)' in /home/badinvestor/public_html/config/connection.php:9 Stack trace: #0 … |
 | hi can u guys help me find what is my error in my line. cmd.CommandText = "SELECT * FROM TblLogin where Username='"+ usr_lgn.Text +"'and Password = '" + pswr_lgn.Text + "'where STAFFSTATUS="+"ACTIVE"+""; im having an error saying incorrect syntax near the word where. thank u |
| | I have a query in sql which i wrote in C#.what the query do is, calculating something like if i have an input of two columns date and no. of balls as Date No. of balls 21/11/2013 2 22/11/2013 3 23/11/2013 4 24/11/2013 5 25/11/2013 2 26/11/2013 5 27/11/2013 4 …  |
| | Hi, I had a little problem in querying something. When defining a project you use work items. And a work item may use a material, labor and equipment. It may not use one or two of them for that work item when it is defined. So for that work item … |
| | Hello All, I am facing a problem coming up with a SQL query for a certain issue: Table 1 ------------------- Client ID|Name of Client|Customer Type|Account Type| 01| A | AB | 30 | 02| B | AB | 30 | 03| C | CD | 30 | 04| D | … |
| | I have an SQL query within ASP.NET, but it only seems to return 1 result rather than filling the list with 4 as it should (as the query itself is correct) Code: List<string> dropItems, dropItems2; using (var dbContext = new DatabaseContext()) { dropItems = dbContext.Database.SqlQuery<String>( String.Format("SELECT locations.Code FROM locations")).ToList(); } …  |
 | Hello, I have one query with timestamp. I got below error. select users.login, FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(ticket_history.create_time)-UNIX_TIMESTAMP(ticket.create_time))) from ticket_history_type inner join ticket_history on ticket_history.history_type_id=ticket_history_type.id inner join ticket on ticket.id = ticket_history.ticket_id inner join users on users.id = ticket_history.change_by where ticket.create_time BETWEEN '2014-10-01' AND '2014-10-15' AND ticket_history.name ='%%new%%Fermeture réussie%%' group by users.id *`error: function … |
 | A Drupal security advisory, [SA-CORE-2014-005](https://www.drupal.org/SA-CORE-2014-005), rather embarrassingly states that: > Drupal 7 includes a database abstraction API to ensure that queries executed against the database are sanitized to prevent SQL injection attacks. A vulnerability in this API allows an attacker to send specially crafted requests resulting in arbitrary SQL execution. … |
 | I'm new to java and I'm working on a small android project using eclipse. I created a table and I want to populate it with data from a file. I have done this using EditText control shown below. public void AddRowItemTable(View view) { EditText itemid_Text= (EditText) findViewById(R.id.itemid); EditText itemname_Text=(EditText) findViewById(R.id.itemname); …  |
 | A question for VB.NET - Access DB folks here, although some might consider a strictly DB question. Is there an order of operation when a SQL query 'does its' thing' relating to the 'WHERE" clause with multiple parameters? In other words, could you rearrange the elements [filters] of the WHERE …  |
| | I have a form that has two parameters amenities and attributes. The amenities parameter has a dropdown menu that whose value gets populated from a separate table. The second parameter is attribute whose value will be entered by the user and will get saved in a database. View of database … |
| | Hello All we want to print datagrid view's 20 records per page, but it seems LIMIT Command is not working and shows error plz can any one help or suggests alternet. this is our coding. ANPSql = "Select * from Table1 limit 0,20" MsgBox(ANPSql) Pth = My.Application.Info.DirectoryPath ANPConn.ConnectionString = "Provider=Microsoft.ace.oledb.12.0; … |
| | After Designing database--->Connection to database--->Data entered-->Data stored in database.My doubt is in which format data is viewed on the screen.(XML OR EXCEL OR PDF) |
| | how to store the users data in sql database from a asp.net form  |
| | Hi there! I have a problem and i want you guys to help me. I have 1 table which has many fields. (mysql and im connected from microsoft visual studio..runs very well so there no problem with this). lets forget the fields that we dont want now.. i have 4 … |
| | I have an Access Database on which I have tables with similar structure and columns name columnA and columnB.I can use the below query on tables created design time to get this output. Table | result -------|-------- SELECT "Table1" AS Table, SUM(a) - SUM(b) AS Result FROM table1 UNION SELECT … |
| | I've been trying to start MySql in XAMPP and I keep getting "**ATTEMPTING TO START MY SQL SERVICE**" as a response. I tried replacing the port from **3306 to 3307**. I already unistalled my other MySql Program. **What should I do for MySql to work**? |
| | I use SQL Server2008 R2. From yesterday, I get a problem to open it. When I try to open it by Microsoft SQL Server Management Studio an error is occurring. And I also get the same error when I call it from vb.Net2010. I am attaching here the error picture. … |
| | Hi! I am doing the programming on my computer and it works fine-the program, the database itself, inserting to the database is also working fine. But when I publish it and install the program on another computer. It crashes and does not execute the `INSERT` command. Here is my code. … |
 | update form mysql does not show file value in update page other input text working well.  |
 | Alright, so the following has stumpted me and a few others in the office, and we just can't figure it out. I have develope a program that allows us to go out to a specific database and search one of the fields based on specified values. Now that seems all … |
| | Hello everyone, So here's an interesting question for you all. I need to know how to retrieve all the Column Names or Primary Keys from one of the specificed database types: SQL Server, Oracle, AS400, IBMDB2. Now this has to be as a query, or more specifically I have to … |
 | |
| | Greetings, I'm using InstallShield 2010 premier and I want to hide the SQL login dialog if the specified database is exists. Or hide the Dialog under some conditions I google for hours and indeed I cannot find a useful information especially I'm not an InstallShield expert  |
| | I have a problem updating table from datagridview in vb.net to sql server. I have posted the code below. I am importing connectionstring from connection module. It used to be working but I dont know what went wrong and now it isnt. Imports System.Data.SqlClient Public Class frmreportsp Dim cn As … |
| | I'm trying to create a store procedure in mysql and it is giving me errors and I don't know why since the sql code works just find. Here is the sql code: CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS ( select AVG(Score) as AVG, MovieCode from UserMovies group by … |
| | Greetings I want to optimize a SQL Query. The problem I have a database full of such Queries and I need help for optimizing those Queries the problem with the Query is that it contains dozens of CASE blocks and within those CASE blocks there are calculations the Query results … |
 | hy, unfor its not showing nothing...what it is wrong...? <?php include('config.php'); error_reporting(0); ?> <table border=1> <tr> <td rowspan="3">Ditta</td> <td colspan="6">mandatori riceve</td> <td colspan="6">mandatori consegna</td> <td colspan="6">saldo</td> </tr> <tr> <td colspan="3">carelli</td> <td colspan="3"></td> <td colspan="3">carelli</td> <td colspan="3"></td> <td colspan="3">carelli</td> <td colspan="3"></td> </tr> <tr> <td>carrelli con piastra luc.rosso</td> <td>carrelli con piastra luc.nero</td> … |
| | |
 | I have created a procedure and a table. I was wondering how can I call my procedure in a sql file and insert the result into my table? |
| | I need some recommendations for the following project Im working on: I have a SQL datbaase on our SQL server that contains all the project information for the company. I want to build a front end form that users can use to search the database and have this form be … |
| | Hello everyone, I am putting together a project where people are able to upload multiple choice questions to a larger database and then create tests from them. I have several questions (and I apologize for the length of this post) about what is the best way to go about doing … |
| | I have the following code: <?php $fieldsClause = array(); $bindArray = array(); $fields = array('status','fname','middle','lname','address','city','state','zip','county','mailing','hphone','mphone','wphone','ext','fax','email','ethgroup','other1','occupation','poe','dob','gender','bhv','mrc','general','evv','allCounties','fillmore','johnson','otoe','richardson','seward','butler','gage','lancaster','pawnee','saline','thayer','cass','jefferspm','nemaha','polk','saunders','york','other2','aro','clergy','intskills','bus','child','law','cpr','data','security','emergency','computer','mechanical','administration','firstaid','translation','construction','basicclean','foodprep','animalcare','heavy','dataentry','identification','phone','runner','greeter','interviewer','safety','other2','interpt','cdl','cpryn','translate','other3','license1','verf1','num1','exp1','license2','verf2','num2','exp2','license3','verf3','num3','exp3','license4','verf4','num4','exp4','license5','verf5','num5','exp5','lsrd','syes','bcert','pauth','dist1','tdate1','dist2','tdate2','dist3','tdate3','dist4','tdate4','dist5','tdate5','felony','felonys','ename','erelation','ehphone','eaddress','ecity','ezip','hdyhau','bdesc','record'); foreach($fields as $field){ if($san = filter_input(INPUT_POST, $field, FILTER_SANITIZE_STRING)) { $fieldClause[] = "`$field` = :$field"; $bindArray[":field"] = $san; } } $sql = "INSERT INTO volunDB("; if (!empty($fieldClause)) $sqlF = implode(', ', $fieldClause); $stmtString = $sql; if(isset($sqlF)) … |
| | I have a app, that requires login with SQL server as backend. I have users who are on laptops and not always connected to the network. I want a way to check for the SQL server, and if it does not exist then roll over to local auth for local … |
| | I have the following code: <?php $fieldsClause = array(); $bindArray = array(); $fields = array('status','fname','middle','lname','address','city','state','zip','county','mailing','hphone','mphone','wphone','ext','fax','email','ethgroup','other1','occupation','poe','dob','gender','bhv','mrc','general','evv','allCounties','fillmore','johnson','otoe','richardson','seward','butler','gage','lancaster','pawnee','saline','thayer','cass','jefferspm','nemaha','polk','saunders','york','other2','aro','clergy','intskills','bus','child','law','cpr','data','security','emergency','computer','mechanical','administration','firstaid','translation','construction','basicclean','foodprep','animalcare','heavy','dataentry','identification','phone','runner','greeter','interviewer','safety','other2','interpt','cdl','cpryn','translate','other3','license1','verf1','num1','exp1','license2','verf2','num2','exp2','license3','verf3','num3','exp3','license4','verf4','num4','exp4','license5','verf5','num5','exp5','lsrd','syes','bcert','pauth','dist1','tdate1','dist2','tdate2','dist3','tdate3','dist4','tdate4','dist5','tdate5','felony','felonys','ename','erelation','ehphone','eaddress','ecity','ezip','hdyhau','bdesc','record'); foreach($fields as $field){ if($san = filter_input(INPUT_POST, $field, FILTER_SANITIZE_STRING)) { $fieldClause[] = "`$field` = :$field"; $bindArray[":field"] = $san; } } $sql = "INSERT INTO volunDB("; if (!empty($fieldClause)) $sqlF = implode(', ', $fieldClause); $stmtString = $sql; if(isset($sqlF)) … |
| | How do I get average of the duration for multiple weeks. Currently I get something like Student Avg completion time Week Year STUDENT 1 0 1 2013 STUDENT 1 5 1 2013 What I want is Student Avg completion time Week Year STUDENT 1 2.5 1 2013 <code> select a.student,avg(a.duration) …  |
| | Try DoInsertQuery("If Not Exists(" & _ "SELECT * FROM tblSchoolYear " & _ "WHERE schoolYear = 'SY " & Trim(txtAddSchoolFrom.Text) & "-" & Trim(txtAddSchoolTo.Text) & "')" & _ "INSERT into [tblSchoolYear] ([schoolYear]) VALUES ('SY " & Trim(txtAddSchoolFrom.Text) & "-" & Trim(txtAddSchoolTo.Text) & "')") Catch ex As Exception MsgBox(ex.Message) End Try … |
| | Hi everyone, For a social system I am working on, I am in desperate need of being pointed in the right direction for how to create a live ajax feed which calls data from a database. Urgently needed, any help much appreciated! Cheers! Jack(Scaasiboi)  |
| | Hi i need to use the below query in PHP to generate PDF but its not displaying what are all the supporting files i need to put for running the below (XML path) query in php,Its running successful in sql but when i put in php its not working can … |
 | I am receiving a Code in sms like "yyyy/mm-digit" (digit increments with every message). so i want to ensure that the code sent by user is exactly in that format otherwise another action. So how ? Here is my code to check but it always execute else block, why ? … |
| | I'll prelude this with I am a novice coder at best and this is mostly a hobby that I would like to do professionally one day, but that day may be 10+ years from now. So for now I tinker and learn here and there. Part of the reason I … |
| | So, I'm at school right now. In programming (actually coding) class. I managed to get working Apache and everything's fine. Got MySQL runnin', which is nice. But then it turned out that I had to use terminal for all the SQL commando's I had to put inside. I'm not close … |
| | This is writen using vb.net and sqlCe. I'm interested how this could be written in SQL server 2008 and vb.net. Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable)  |
| | Here is one that is stumping me. I have an Access 2000 database backend. It got corrupted. It is a large database. I compacted and repaired it and a record came up corrupted. There was a compact error table created that has a binary column in it. The binary column …  |
 | Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 O 01/03/2014 18:00 02-0009 I 01/04/2014 8:00 02-0009 O 01/04/2014 18:00 For every date there should be a 'I' and … |
| | i am trying to figure out the syntax to do a SQL inner join from 2 different databases... The sameple code looks like this: select * from database1.dbo.table1 t1 join database2.dbo.table2 t2 on t1.field1 = t2.field2 but I dont know how to refernce the " database1.dbo" and "database2.dbo" parts.. can … |
| | I need to setup SQL Server Express using the command line and also make the installation unattended I tried many command lines however each one of them did not work here is the last one: Setup.exe /ADDCURRENTUSERASSQLADMIN="True" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVIC" /AGTSVCSTARTUPTYPE="Disabled" /ASBACKUPDIR="Backup" /ASCOLLATION="Latin1_General_CI_AS" /ASCONFIGDIR="Config" /ASDATADIR="Data" /ASLOGDIR="Log" /ASPROVIDERMSOLAP="1" /ASSVCSTARTUPTYPE="Automatic" /ASTEMPDIR="Temp" /BROWSERSVCSTARTUPTYPE="Disabled" … |
 | I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time … |
| | the relation betwwen student and course entity is many to many.but it is not recommended .how can we convert it to two one to many relationships? |
The End.