1,694 Topics
|
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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... |
|
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 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 … |
|
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 … |
|
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 … |
|
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 … |
|
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" … |
|
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 … |
|
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 All I am running an sql query to obtain the data for $CaseStudyTitle[] = $row['CaseStudyTitle']; located in the while loop and passed as parameters to the fucntion below. Currently I am displaying only one case study title at anytime. The partner can have many case studies titles how can … |
|
Hello, I want to make a conditional SQL. I have one table "users" and it has two columns (id, status) I need to search for users IDs based on their status. For example. Every 5 seconds I am querying from the database (by AJAX) as per the below description: Let … |
|
Im writing some code to send out emails for work. And i've been stuck on with this error for a while nw. Any help will be greatly appreciated. Error message: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\PHP\mailMany.php on line 21 Heres my code: <?php // … |
|
Dear All ! I have a table member_email. i have 4 columns in it. Id Email CellNumber Carrier I want to create constraint who check following conditions, 1-Email can be null if Cellnumber is given , and Cellnumber can be null if email is given. 2-both email and cell number … |
|
I came up with this query now when i tried to create a view it failed to create SELECT aDate FROM ( SELECT @maxDate - INTERVAL (a.a+(10*b.a)+(100*c.a)+(1000*d.a)) DAY aDate FROM (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 … |
|
Hi all I am experiencing the following error. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean givenit refers to line 94 which is the while loop start point. Thanks in advance D <?php $x=0; $remainder=0; $image_value = array(); $partners_id = array(); $description_value = array(); $url_value= array(); $image_filename_value = array(); … |
|
Hi All, With SSIS, upon load, I am receiving the following error: > Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1 I have gone through all of my connections … |
|
Hi all I have an sql output query problem I am trying to resolve. The problem is that I have centres that offer Awards and quals and some centres only offer awards or quals only. What I need to process is the centres that offer both awards and quals. tbl.net.qualification … |
|
Hi all I am request the following data from the database (image_id and description). I need to put each of them in a separate arrays and then echo out contents of both arrays I have tried array_push and implode without success. Any assistance would we appreciated. Thanks in advance D … |
|
hi, I am working on an asp application using c# and i can import excel file to sql table i have two columns in excel and as well as in sql of same name "id" and "status" when i import data both columns are imported to sql table in the … |
The End.