6,934 Topics
 | |
| | how to dump mysql file to desktop using vb.net button  |
| | I have a page to add products. On this page is a 'categorey' dropdown and a 'subcategory' dropdown. The subcategory dropdown should fill with the options based on the category dropdown selection. The code I have so far does not fill the subcat dropdown, can anyone see a problem? code …  |
 | I am new to vb.net Pls. Can someone help me on how do to display my data saved into sql server from form1 to datagridview in form2 with vb.net. Thanks in advance.  |
| | Hey everyone, I am trying to create an excel spreadsheet that is populated with data from a table in sql server. I would like to make it so it will update several times a day with out the user having to do so. I have no clue how to go …  |
| | I am using vb.net ajax to load a crystal report located on the server - sometimes it works and other times the call to .export just hangs sql server and we have to restart the sql server. I can't find any discussions of this error anywhere and I'm sick of … |
| | One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run … |
| | how to create xml file from a database table using vb.net I tried a code but it doesn't retrive values from the database table How to resolve this And my code is: <%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="true" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> … |
| | how to retrive values from database into a table using vb.net?????? I tried but i don't have either output?????? How to do this??? and my code is: <%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled … |
| | Pls. How to back up sql compact database and restore on another computer not having sql database  |
 | I am trying to learn SQL programming in my spare time, but I'm running into some issues. I currently have Visual Basic Studio 2010 installed, as well as Microsoft SQL Server 2008/2012. I've been told that I should be using MySQL to practice the coding. Should I lean towards MySQL … |
 | I am working on a mapping system to support pathfinding over areas that are too large to hold in memory. The problem i have run into is how to load only a small part of the map when its all linked together and then dynamicaly load more of the map …  |
| | I have a mysql query that seperates an array of variables and uses each variables to compare inside the database. The query uses a OR clause and I want to make it so it can also use an AND clause. The trick is I want the left side of the … |
 | I need the steps to make an daily Back Up to my data base i am using SQL 2008 and when i do the backup job it gives me an error unsuccessfull complete , any one can tell me why ??  |
| | hi every one , can some one give me an idea or code of how to save .PDF file and .dwg into sql server and preview these file using image box in vb6 if can ???? |
| | Hi guys, I added a extra line of code to test for records in the database and if they exist to update them before inserting them instead. For some odd reason it's not working and it simply just inserts the data causing duplicates. Any suggestions? <%@ Import Namespace="System.Data"%> <%@ Import …  |
| | Hi Folks, Recently I installed WAMP server for web development, during my first run I tried My Sql Console, but I was gettting error while creating a new table. I am surely missing something. I googled for it but cannot get what i was looking for . . . Am … |
| | Hello my fellow Daniwebies! I have a curious, possibly unique, and odd problem for everyone! We support an ASP.NET application which is using VB.NET for code behind. We use LINQ to SQL and classed object for the data retreival. I have an object called...myObject which is being deleted: Public Shared … |
 | <?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","wordup","inthekitchin"); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $res = $mysqli->query("UPDATE plate1 SET potatoes =('$_POST[potatoes]') WHERE id =('$_POST[id]')"); $row = $res->fetch_assoc(); ?> returnes error `Fatal error: Call to a member function fetch_assoc() on a non-object … |
 | I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i … |
 | Hi All, Hopefully I don't get too scolded here for this question but I can't commit my mind to answer this as I have been ill and am still not fully recovered. In saying that, I have the following set of tables (see pic) and I need to fill in … |
| | What is the error in the folloing code? I am not able to add data to the table cmd.CommandText = "insert into master (FirstName, middlename, lastname, [addressline 1], [addressline 2], city, pincode, state, country, Nationality, sex, DOB) values ('" + textBox1.Text + "', '" + textBox2.Text + "', '" + …  |
| | i want to ask you when i execute the following sql statement SELECT account_identifier,least(to_number(part_1)),least (to_number(part_2)) FROM TEST5 ; i get the following error ORA-01722: invalid number 01722. 00000 - "invalid number" you should know that when i execute the following sql statement SELECT account_identifier,to_number(part_1),to_number(part_2) FROM TEST5 ; it works fine |
| | Ok so im working on a mapping library for my pathfinding system and im trying to figure out what Data structure would be best to use for rapid calls up to several hundred a second, as low memory usage as possible, and not too difficult to store and load pieces(chunks) … |
 | Hi All I just want to know the following thing; When SQL Functions are used? Provide a couple of examples of situations in which they are necessary. Awaiting response... Also can anyone refer me a ebook for SQL for beginners in which Functions is desscribed detailed... |
| | [B]insert.php[/B] [CODE]<?php $dbun = "$_POST[dbun]"; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $con); $sql="INSERT INTO $dbun (sn, date, particular, dr, cr) VALUES ('$_POST[sn]','$_POST[date]','$_POST[ptr]','$_POST[dr]','$_POST[cr]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con) ?> [/CODE] [B]DB name = my_db[/B] [B]user.php[/B] …  |
| | I've built a SQL report in MS SQL Server Report builder for our ticketing backend. I want to be able to do custom reporting. I've created this report by using the following query: SELECT SR_Service.Date_Closed ,SR_Service.Date_Entered ,SR_Service_SLA_Workflow.Responded_Minutes ,AVG(SR_Service_SLA_Workflow.Resolved_Minutes) AS Avg_Resolved_Minutes ,SR_Service.Hours_Budget ,SR_Service_SLA_Workflow.SR_Service_RecID AS [SR_Service_SLA_Workflow SR_Service_RecID] ,SR_Service.SR_Service_RecID AS [SR_Service SR_Service_RecID] ,SR_Service.Company_RecID … |
| | I have created four tables in apex oracle and I also need to create four statements which display information from all four tables or just a few of the tables, I have tried writing up advanced statements myself but they are not advanced enough, can someone please help? |
| | Hi there, This question relates to data structures, performance and approach to a problem. It is best explained with example so bear with me. For the record, I will be using a combination of PHP, MySQL and Apache server on a dedicated Linux server. The problem is how we would … |
| | Hello, I need to know what's the best way to search tables with million records. I have a table called <people> and this table has the column: <status> Status might be more than one word like: "I am happy today and the weather is nice". Also, it might be in … |
 | I am trying to interact with my wqordpress database. I need to upload a csv file to my database but it will not run any query, no matter which way I try using the WordPress codex, I cannot get it to do what I need to. So from my Admin … |
| | Hello I have these database countries ->country_id ->country_name ->language counties ->county_id ->county_name ->language towns ->town_id ->town_name ->language locations ->location_id ->location_name ->language streets ->street_id ->street_name ->language and i have users that select country,county,town,location and optional street at a selected language and i want to show the show the informations of address … |
| | <?php $username = $_SESSION['username']; $result = 'sample'; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } $sql = "Select FirstName from Person Where LoginID = (Select LoginID from UserLogin Where Username = '$username')"; $result = mysql_query($sql,$con); echo $result; ?> I'm kinda new to this server-side scripting … |
 | Hi All, Is there any way to read/extract data from sql server backup file without restoring it? Thanks. |
| | Write a select statement that will display student id, student last name and the number of courses a student has been enrolled. You will need to join two table, use a COUNT aggregate and a GROUP BY clause in your SELECT statement. this is something i found on internet, im … |
| | Hi I have an issue where by I have lots of products in a field which are comma delimited I want to replace those product words with a id number that I have in a different table. I currently use FIND INSET to replace a tab to the comma but … |
| | 1. Display student id, student first name, student last name, the students’s faculty advisor id, advisor last name, advisor location and phone number. You will join uc_student and uc_faculty 2. Write a SELECT statement that will return the faculty last name, faculty first name and the room for faculty whose … |
| | How do you create lists in an APEX form which allow many checkbox selections? How do you store these in database? |
| | Hi, I want to use session state in mode SQL Server I googled some parameters to add in `<sessionState mode="SQLServer" />` in web.config file like: * Sql command time out. * State network time out. * Compression enabled. * Max pool size. * Min pool size. So I have some …  |
 | There is two sections i need it to update. When they hover over the members name listed below, I need it to show their details. When the user(one who submitted the content) posts its going to have a hidden value to update the field in the form that i have … |
 | Hey Guys, I am writing this code to send out personalised emails to potential customers. And i have few questions about the code. This code is made from several tutorials and code examples. I have searched for stuff on it and theres plenty of articles about it but not what … |
 | **I got this error on line 369** Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a4670304/public_html/lol.php on line 369 <?php // session_start(); require_once('auth.php'); include("dbconnection.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="icon" href="img/Untitled-1.png" type="image" /> <link rel="shortcut icon" href="img/Untitled-1.png" type="image" … |
| | Hello, I have a mysql query $query = "SELECT * FROM comments WHERE commenter_username IN (" . join(',', $list) . ") Or Number IN (" . join(',', $list) . ") ORDER BY comment_id DESC"; I want the query to select one row, the row with the highest id. Then store …  |
 | Hi All, What Wrong with my QUERY ! it show Repetition of Record in INNER Join i.e when i have 3 record in database it show it 9 time using This query.... SELECT dbo.EmployeeSetup.EmpID, dbo.EmployeeSetup.EmpName, dbo.EmployeeSetup.FatherName, dbo.EmployeePayment.Designation, dbo.EmployeePayment.Department, dbo.EmployeePayment.Salary, dbo.EmployeePayment.Advance, dbo.EmployeePayment.Deduction, dbo.EmployeePayment.OvertimeAmount, dbo.EmployeePayment.PaymentDate, dbo.EmployeePayment.ModeOfPayment, dbo.EmployeePayment.NetPay, dbo.EmployeePayment.PayMonth, dbo.EmployeePayment.Fine, dbo.EmployeePayment.Fund, dbo.EmployeePayment.Insurence, dbo.EmployeePayment.Tax, … |
| | Ok so im reading int values from an sql database but then the "Executor" comes back as a hex value and it is declared as a int value in sql..all the bit field values i have comes back correctly accept the int values. can someone help me ons this, what …  |
| | Hey guys, New to the site, new to writing SQL queries and have no background in this type of thing. But I've been googling my way to victory for the most part. I'm struggling on probably a very simple problem. I'd like to Sum the contents of a column, if … |
| | I'm going back to an old project to apply things I've learned. As a beginner, I was able to figure out how to change the query, based on what was chosen, but it seems like a backwards way to do it, and I'm not sure of a better way. I'm … |
| | Hi, i'm doing a website where the user can add his favourite bands in his profile. But not every band is in the DB, so if the band isn't in the DB it adds the name in the column. this is what i have: if(mysql_query("INSERT INTO bandas_fav(band_fav_id_user, band_fav_id_banda) VALUES('".$_GET['iduser']."', '".$bands_name['banda_id']."')")) …  |
| | Hi, Me again... Just wanted to know, i have this piece of code to enter the data from a registration form of mine into the user db. I want to use the mysql_real_escape_string to help stop those evil people who enjoys hacking from hacking my DB $query = "INSERT INTO … |
| | Hi, I have a string formula and I wanted to execute it in sql server 2008 UDF function. Please suggest to proceed. P.S. I have tried with exec () - error occurred.  |
 | I am stuck on the final part of the query, I know that this thing is easy, but I am out of ideas now, so sorry for this. I have prepared a query like this: SELECT A.projectName as PARENT, (select COUNT(*) from PSPROJECTITEM WHERE PROJECTNAME = A.PROJECTNAME) parentprojecount, B.ProjectName as … |
The End.