6,934 Topics
 | |
| | Hey guys I have found this code to create a quiz, I'm getting the following errors when I try and add a question Warning: require_once(scripts/connect_db.php): failed to open stream: No such file or directory in C:\xampp\htdocs\addQuestions.php on line 33 Fatal error: require_once(): Failed opening required 'scripts/connect_db.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\addQuestions.php on … |
 | I have a datagridview with 10 rows I can select mutiple rows by using Ctrl & Mouse click but what I would like to do is use a button to select the row. I.E the user could select row one, click the button and row one would be selected then … |
| | Hi I need to delete words before a set of words in a field. eg delete the words before the word price in that field. I already have a query to replace a certain word but cant see how adapt it to do what I require update TABLE set `field` … |
 | Hello to everyone. I have this table: CREATE TABLE `documents_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `active` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; I am trying … |
| | Hi, I was wondering if there's a way to check an existing id in the main table when using temporary table,then use another id for inserting records.Since it may cause error for using the same id in the main table. Is there a way to do that? |
 | Ok, I ve been struggling for the last two weeks to get my webservice working on somee.com. I managed that. Then my database corrupted but managed to get it migrated it to mysql before that and everything' s fine. Now the final problem that I have and just can't solve … |
| | I am currently trying to link a mysql Stored Procedure to a Microsoft SQL Reporting Server. It is coming up with a Syntax error. I believe this is down to the Date_from and Date_to Parameters. The query is below any help would be appreciated DELIMITER $$ USE `mydb`$$ DROP PROCEDURE … |
| | I was wondering if there is any way to do a single mysql query to do a count of filled positions in a multi-level structure to an indefinite depth. That sounds a bit cryptic, but this is what I would like to do if it is at all possible. we …  |
| | Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for … |
 | This is a function that I wrote and have re-used many times. I share it with you DaniWebers to use, laud or destroy! In a nutshell, this takes a user's search box input phrase and generates a series of LIKE clauses for your SELECT statement. Looks like "col1 LIKE '%s_term1%' … |
 | dear friend i want to insert a row in orecal which is insert into employee ('AMIT D'SOZA', 'MANAGER','500') thorugth php but there is problem to insert data like 'AMIT D'SOZA' so i want to restrict "'" (singal quets ) to enter in text fields plz help me if you have … |
 | |
 | Hey guys, I'm not very familiar with asp.net (Doing this in c#) or session cookies for that matter, just the basics. Trying to store a list of items in a session cookie, then when needed, pull those items back out as a list to then use them in a MS …  |
 | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks |
| | COMBINATION_ACIL contains column: id (primary) prodcode [group] alias lastupdate updateby and here is the steps when i import xml to sql DECLARE @COMBINATION_ACIL AS xml SET @COMBINATION_ACIL = ' <Product> <product> <PRODCODE>CADB</PRODCODE> <GROUP>CADB</GROUP> <ALIAS>ADB</ALIAS> </product> <product> <PRODCODE>CI50</PRODCODE> <GROUP>CI50</GROUP> <ALIAS>I50</ALIAS> </product> <product> <PRODCODE>CI80</PRODCODE> <GROUP>CI80</GROUP> <ALIAS>I80</ALIAS> </product> <product> <PRODCODE>HOSBA</PRODCODE> <GROUP>HOSB</GROUP> <ALIAS>HOSBA</ALIAS> </product> … |
 | I'm trying to create a table but I keep getting errors: Here are the errors: mysql> source Tables3.sql; Database changed ERROR 1064 (42000): 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 …  |
| | I found a php class that seems to help me achieve my objective of doing an advanced search of my database <?php class search { var $table; var $field1; var $field2; function queryRow($query){ //define database settings define("host", "xxxxxxxx"); define("login", "xxxxxx"); define("senha", "xxxxxxx"); //define database name define("data", "xxxxx"); //conection routine try{ … |
| | Hi, i have develop an window application using **VB.NET** and** SQL SERVER2008R2**.I have Sql server2008R2 installed on my system containing sql database file.I have my connectionstring in app.config file as:- <appSettings> <add key="mycon" value="Data Source=My-pc;Initial Catalog=MovieCatalog;User ID=sa;Password=pwd123" /> <add key="ClientSettingsProvider.ServiceUri" value="" /> </appSettings> Now what i want to do is … |
 | Dear all, I have been thinking of this task, but I have no idea where to start from. I am retrieving login logs from the database, which is cool. Now, the challenge is that in case a user has logged in more than once in the same day, I want … |
| | i need to copy my data from access database to sql database through coding in vb.net , and taking into consideration the duplicates each time i select from access database to copy to sql , any help thx |
| | anybody to help me query two database tables containing different data between two dates and results given sequencially dependending on this dates on either of the two said tables |
| | Hey there. I'm building a project in PHP/MySQL and it is a sort of [FaceMash](http://en.wikipedia.org/wiki/History_of_Facebook#Facemash) project. I am able to call the images (with image name and points) from the database. I have managed to use the MySQL Update query in order to increase the points that each image gets …  |
| | Hi guys I know this might be a repeated post, someone has looked at the code and they seem to think that it all look fine, but I'm getting this following message again Warning: mysqli_query(): Couldn't fetch mysqli in C:\xampp\htdocs\submit-form.php on line 19 The following SQL Failed INSERT INTO 'users' … |
 | Hello Everyone, I am trying to achieve pagination using jsp javascript and servlets. Here is my code below: SearchUserViews.java `package TestPackage; /** * * @author Sagar */ private String _userid; private String _firstName; private String _lastName; private String _emailAddress; public userProfile(){ _userid = ""; _firstName = ""; _lastName = ""; …  |
| | Here is my PHP code: $fields=array('eventID','eventTitle','te_events.venueID','te_events.catID ', 'eventStartDate','eventEndDate','eventPrice'); // initialize empty array for WHERE clauses $wheres=array(); // loop through field names, get POSTed values, // and build array of WHERE clauses, excluding false values foreach ($fields as $field) { // get existing field value from POST, mark missing or empty … |
| | i am not able to connect to the sql server on my system. SqlConnection^ connection=gcnew SqlConnection(); connection->ConnectionString ="Data Source=blueboy\sqlexpress;Initial Catalog=DCV_DB;Integrated Security=SSPI;Pooling=False"; i got the string from database properties.(i have attached the same in this post) sql service is running. tcp ports are enables too. |
| | i have a works to create table report like in attached image.  i don't know how to arrange the days and grouping as Time, thank you for help... |
 | Can any guy tell me what is the differnce between a datareader and a dataadapter? Also what are the other method to search data through SQL queries?? |
| | So, if - like me - you find yourself in need of installing SQL Developer on Ubuntu 12.04 and have for some or other reason ended up downloading the rpm instead of the zip from the Oracle [site](http://http//www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html) or you already have an rpm of SQL Developer lying around follow … |
| | We're learning pl sql in class, and I was just wondering if anyone noticed any glaringly obvious errors in my code? --Gets the phone number of a specific member set SERVEROUTPUT on DECLARE phone_number Member_T.Phone%TYPE; BEGIN SELECT Phone INTO phone_number FROM Member_T WHERE MemberCardNumber= 2436322287; DBMS_OUTPUT.put_line (phone_number); END; --Uses a …  |
 | I have huge csv file that i need to load into database using sql loader. In the file, there are columns enclosed by ", but some of them is not and in these columns there are single quotes and I would like to know how to deal with them (I …  |
| | Hi Guys as I have mentioned before I'm having problems with connecting my website to a sql database, config.php <?php ini_set('display_errors', true); // change to false when you go live error_reporting(E_ALL); //Mysql Connect | mysql_connect("host= 3306","username",""); //Below example to connect in localhost //$a=mysql_connect("localhost","root",""); if($a == false) { die("Connect failed: ".mysql_error()); … |
 | I all as anybody tried, passing a pdf tha is in memory stream and so it directly on a div, without the creatio od a file?? Best Regards  |
| | I have this file named - " CUST.dbf ", how can i use this file to be able to import on MySQL for me to access the records on the table? Thanks in advance. more power |
| | Hi, Hi I only want to select 5 rows. Can you please tell me how to do it in sql? Thank you. example: ratee rater apple banana apple orange apple peach apple sunkist apple mango apple grapes grapes orange I want to see random selected of 5 ratee orange with … |
| | Good afternoon, I'm trying to formulate what should be a simple query that will create a result set of ALL records from a table that have a date that is in the previous month... Basically something like this one that I use that gets any records prior to the current … |
| | how i can import data from access database to my database in sql server , with a check for ducplicate each time i move data i need the code in vb.net any help ? |
| | [code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click connetionString = ("server=192.9.200.82;database=eKalyan;user id=invite;password=invite") MessageBox.Show("connection established") sql = ("select newuniqueid,newteh_code,newpcate_cd,newplano, pen_nm,rel_cd,pen_fnm,ccate_cd,pan_code,pvillage,ppo_cd,spo_cd,start_qtr,last_qtr,bundle_typ,bundle_no,mo_srno,pen_amt,pen_comm,status,operatorcode from ekalyan.welpen") cnn = New SqlConnection(connetionString) Try cnn.Open() cmdd = New SqlCommand(sql, cnn) cmdd.ExecuteNonQuery() cnn.Close() MsgBox(" ExecuteNonQuery in SqlCommand executed !!") Catch ex As Exception MsgBox("cannot … |
 | Hi everyone, I'm new here and is in need of some help. I'm trying to complete my project, however I'm stuck at writing the data from the sql into the vb.net/asp.net gridview. Was never good at database to start with and I had never learnt how to query from VB.NET. … |
| | Hey all, I am trying to update submissions from my SQL database from an edit page via an edit link in line with the submission which captures the ID of the database entry. When I click the edit link a new page opens and it has a form to update …  |
 | Hi, How to use in select statement with where condition comparing a Null value and with value? I have this Statement `Select Col1, Col2, Col3 From Table where DateDeleted` 'Here comes the problem The condition is something like if DateDeleted (which is actually a date) is Null then get records … |
| | Good Morning All, I'm about to write a script that will actually be run in a CRON job weekly. I created an overview of the process so you would understand what I'm doing but I have questions with 2 of the MySql queries that will be required, and wondered if … |
| | I m getting the following error when trying to add a .mdf file and .log file to my account on somee.com ERROR--> "You don't have the permission to open this file, contact the file owner or a administrator to obtain permission". I need to get my database on the server …  |
| | 1. For all the accounts that have authority="admin", set permision to modify all of the files (attribute changes is datatype YES/NO),,, so basically a user can set yes or no depends on his will. 3. For each directory, print out his name, in which directory it is located, and how … |
| | Hi Guys when I click on the submit button on my register page I'm getting the following errors Notice: Undefined variable: a in C:\xampp\htdocs\submit-form.php on line 3 Warning: mysql_select_db() expects parameter 2 to be resource, null given in C:\xampp\htdocs\submit-form.php on line 3 Deprecated: mysql_connect(): The mysql extension is deprecated and …  |
| | Hi guys I'm still having trouble actuly letting users register with my website. I need a simple PHP and SQL script that I can use and the scripts that I have wrote are not working correctly and I'm now getting really stressed out about it |
| | hi Team, i am facing 1067 error while starting My SQl service in windows. share your suggestions for this request. OS: windows 7 pro 64bit AV: Symantec 12.14013 Thanks Shiva  |
| | Hi Guys I'm connecting to a database using PHP and MYSQL, here is the code <?php $firstname=$_POST['firstname']; $lastname=$_POST['lastname']; $username=$_POST['username']; $confirmusername=$_POST['confirmusername']; $password=$_POST['password']; $confirmpassword=$_POST['confirmpassword']; $email=$_POST['email']; $confirmemail=$_POST['confirmemail']; //Database connection require_once("config.php"); //mysql query to insert value to database $query=mysql_query("INSERT INTO registration (`firstname`, `lastname`, `username`, `confirmusername`, `password`, `confirmpassword`, `email` ,`confirmemail`) VALUES ('$firstname', '$lastname', '$username' , … |
 | Hi folks, I have a question regarding auto-generate row oracle using sequence. So the deal is, I need to make a list of inventory based on its quantity. So I have a table with 3 columns, 1. Component ID 2. Quantity 3. Sub_component. So when user input a component id … |
 | <?php $host = "localhost"; $user = "root"; $pass = ""; $databaseName = "foresight"; $tableName = "userinfo"; $con = mysql_connect($host,$user,$pass); $dbs = mysql_select_db($databaseName, $con); $result = mysql_query("SELECT * FROM $tableName where flag != 1"); //query $email = mysql_fetch_row($result); //fetch result mysql_close( $con ); ?> <?php $connection = mysql_connect("192.232.240.245","root","causealmedus-1608"); if (!$connection) { … |
The End.