2,569 Topics
 | |
| | Ahoy, I'm having a bit of trouble executing a stored procedure using PHP's SQLSRV package thing. It's pretty much just a simple select query, with the parameters being passed through a php (it's from a property search). SqlSrv is a tough nut to crack as docuemtnation is either non existent, … |
| | hi everyone , write now i have a with data which i want show the in tabular format like my query gives output like Name Location Rate AA A1 56 AA A2 27 AA A3 67 AB A1 56 AB A2 27 AB A3 67 BB A1 45 BB A2 …  |
 | Hi All, How i can restrict the numbers of customer from database? I use adodb with access. I know how to retrieve customers from database but i don't know how to restrict it to spesific numbers. Best Regards. Sturdy |
| | Alright everybody! Here's a whopper for you. I've looked over this for the longest time and just can't figure it out. I want to update my database with the user's information when they save the html form. I'm guessing there's like a quotation mark or comma misplaced or something, and … |
| | Hi, I have created the following code to get connection object to Database(MySql in my case) using a static method. I wanna know whether it is a good practice or not? Will there be any problem like concurrent access? Any information will be helpful. public static Connection connection(){ Connection conn …  |
| | Hi everyone. I am making an application that you need to sign up and login to. I want to use an online SQL database to store the login information. I know how to use a local SQL database, but I want to use an online database. Please help :) BTW, … |
 | Hi there I have a few lines of code that I would like to ammend but have been unsuccessful in doing so. I have posted in a few other forums with no luck, hopefully somebody here can help me out. I have a delete statement which I have been asked … |
 | Could you guys show me how to create a progess bar which discribes the process of a SQL procedure?  |
| | What I tried was using `My.Computer.Network.DownloadFile()`, and created a shared folder in the other computer to do downloading stuff. But, in fact I didn't know how to fill the path to the other computer, the error was: *"...path not supported..."* How about this: ServerName1 = cmbServerName1.Text.Trim() database = cmbDataBase1.Text If … |
 | I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,Timeout I want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them. here is my code so far, but it aint working Public … |
| | Please I am currently working on a web application project that works on both the desktop and mobile devices also. The web application is to be for all and sundry and therefore I need it to work on all forms of mobile devices (old and new). The web application uses …  |
| | In my datagrid my sql statement uses a have clause to get set information and i am having countless errors My code is as shown below, were am i going wrong ` con.Open() cmd.Connection = con Dim da As New SqlDataAdapter("SELECT MONTH(Head.SalesDate) AS Month, Detail.ProductID, Detail.Qty, SUM (Detail.Qty) AS TotalSold, …  |
 | I am trying to learn how to make a mobile phone communicate with a server and a database. So far, I have made a web-service on my PC using this tutorial: http://msdn.microsoft.com/en-us/library/ms733069.aspx The above tutorial makes a sortof WCF service. What would be the best Database system for me? Simplicity …  |
| | Hello, I'm having a problem using the jTable plugin. I'm fairly new to using jquery. Here is my problem: I have an database name reg and has fields (fname, lname.....avatar). What i want is to show the contents of the database using jTable. Now, I don't know how to display … |
| | Hey below is a table i created ProductId ----- Qty ------- 1 ----- 2 ------- 2 ----- 2 ------- 1 ----- 2 ------- 1 ----- 2 ------- 2 ----- 2 ------- 1 ----- 2 ------- Wat i am trying to do is get my sql statement select and display my …  |
| | I have a table 'Asset' with a column 'AssetDescription'. Every row of it has some group of words/sentences, seprated by comma. row1: - flowers, full color, female, Trend row2:- baby smelling flowers, heart Now if I put a search query like:- `select * from Asset where contains(AssetDescription,'flower')` It returns nothing. … |
| | Hi, I am vishnu kumar. I knew the basics of Java but this is the first time i am building a project based on java (Java Swing actually). This is my final semester project and for last two months, i am doing my project. I initially thought the database(along with … |
| | what are requirements for sql server 2005 installation? how to connect it with netbeans> can we make no. of instances?how and why?  |
| | Currently i am working and using a filter function for my search however i not sure how to do it using a query the sql statement is [CODE]cmd.CommandText = select * from tblcustomer where customerName like "'& textbox1.text &'"[/CODE] I no there is some bits missing but i am not … |
| | Hi i am making a stored procedure with multiple select statements when i execute them than different resultset are maken for each select statement all i need is to get one resultset from all select statements of sql quries in the stored procedure......HERE is the SP code..[CODE]SET NOCOUNT ON; Select …  |
| | hello! i have shifted my application from mssql server 2000 to mssql server 2005 , now the prob is the command object is not returning the recordset if command text is stored procedure , here is my code please check it and guide me through errors . [ICODE] dim cmdsp …  |
| | Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Thank you Question: 1. (a)modify the addnames.php script to read in and store two fields of data – … |
| | I'm having some issues with this code: [CODE] Imports System.Data.SqlClient Public Class loginForm Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load '--Connection string to POS database Dim loginFormConnection As New SqlConnection("SERVER = localhost\SQLExpress; DATABASE = POS; INTEGRATED SECURITY = true;") '--Check to see if Windows Point …  |
| | Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Also i struggle in this questions as i do not get it fully(in fact i dont get what … |
| | Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Question 3. Write a script to search for the properties which match a postcode (call it search.php ). … |
| | I have a combo box which help me select SQL servers in my local computer, but now I want it to be able to select just any connected servers (like remote servers) as possible, how could I solve it??? [CODE] Sub server(ByVal str As String) con = New SqlConnection("Data Source=" … |
| | Hi, I am having problems with deleting part of a record. The record has approximately 15 different fields, and I only wish to delete 3 of them using the following piece of SQL coding: DELETE [PMID 1], [PMName 1], [Price 1] FROM Subscriptions WHERE [Customer ID]="001" The code works absolutely … |
| | Hello, I have this multiple checklist and I cannot figure out how to enter the checked values into the database. The table is called "colors" and the column name is "color" and is of type "text". add_color.php [CODE] <?php // connect to database require "mysql_connect.php"; ?> <?php // get value …  |
| | Hello everyone, assuming i want to write some values into my database of choice i found two ways to do this. [CODE] my $sql = "INSERT INTO table (foo, bar, foobar) VALUES (?, ?, ?)"; my $sth = $dbh->prepare($sql); foreach(sort keys %hash) { $sth->execute($_, $hash{$_}, $some_other_value); } [/CODE] as opposed … |
| | why is it sometimes i get an error? it doesn't highlight the error [B]CODE[/B] [CODE]Dim SqlQuery As String = "Select UserName from Login" Dim SqlAdapter As New MySqlDataAdapter Dim SqlCommand As New MySqlCommand Dim Ds As New DataSet Dim i As Integer With SqlCommand .CommandText = SqlQuery .Connection = sConnect … |
| | Hello Every one can any body help me how to start with ssrs(sql serevr reporting service ??how to isntall and configure it.. I have SQL server 2005 installed on my machine.. Thnaks |
| | When Creating a query using the sear Criteria Builder . I keep getting the error : " The schema returned by the new query differs from the base query " I no this means that the error is due to the query attempting to return too little columns i have …  |
 | Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data … |
| | Hi guys well I have successfully got my update query to work correctly. Now I have two tables in my database. What I want to do is when I click my play button not only does it update my column's in my first table but all updates my colunms in … |
| | Well, when almost finishing this tutorial: [INDENT][/INDENT][url]http://msdn.microsoft.com/en-us/library/ff677562.aspx[/url] I found a problem on connecting the Add-in to the database, and so the lobInstance can´t be opened: [url]http://i.stack.imgur.com/AFzie.png[/url] This is the error code. (in fact the error message was being popped out when the Excel 2010 client starts, but I commented the … |
| | I want to manually test my sites to check if they are secure against SQL injections. Whats a good way to attempt it. How do I get started? thank you |
| | Hello, I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? Could anyone list out the steps that should be performed. I saw the concept of … |
| | Hi everybodies! How increase ProductId inside Product_Table when insert a new product according to following approach? Language_Table: Id Code --------- --------- 1 ka 2 en Product_Table: ProductId ------------- 1 2 Product_Translation_Table: TranslationId Title ProductId LanguageId -------------- ------------------- ------------- ------------ 1 Kompiuteruli 1 1 2 Computer 1 2 3 Radio 2 …  |
| | Hi all, first post here, please excuse the newbieness!! I am a complete and total beginner to web development in all forms other than mediocre HTML and CSS. Please be gentle and use small words!! :-) I have recently installed Microsoft's Visual Web Developer 2010 Express in order to have … |
| | I want something like how facebooks wall works but when i call what others have posted its out of order with time for example: First Table (Users): UserID: 1, Name: Matt, UserID: 2, Name: Bob, UserID: 3, Name: Steve, Second Table (Friends): UserID: 1, FriendUserId: 2 UserID: 1, FriendUserId: 3, … |
 | this is my query for displaying monthly business [CODE]select convert(varchar,dateadd(month,datediff(month,0,inv_date),0),101) as 'months with date format', sum(inv_amount) as 'business' from invoices inner join customers on customers.cust_id =invoices.cust_id where fname+' '+lname='lala fazlani' group by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) order by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) [/CODE] So when I execute this command, It gives me this result [url]http://img821.imageshack.us/img821/6492/sqle.jpg[/url] [url]http://img341.imageshack.us/img341/538/chartv.jpg[/url] … |
| | Hi, I have problem with evaluating XPath with query. When I use this in xpath_tester script: [B]URL: [url]http://www.seznam.cz[/url][/B] [B]XPath: //*[@id='gadget-6']/div/div/h3/span[1][/B] Works fine, but this: [B]URL: [url]http://www.seznam.cz[/url][/B] [B]XPath: //*[@id='gadget-1']/div/div/div/div/table/tbody/tr[1]/td/div/div/strong/a[/B] Result: "ERROR 2: No result!", because there are no items in $nodeList I'm 100% sure XPath is OK. (using XPath checker extension … |
| | Hi.. I'm developing a website for the first time in visual web developer using asp.net and sql sever database. I have designed my pages and master page. I have created my sql server database too. Please could you help me how to connect the database to asp.net master page? Also … |
 | I have this error appearing Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /websites/123reg/LinuxPackage21/th/er/ag/theragereport.co.uk/public_html/feed/feed_view.php on line 148 from this code [CODE]$sql3="SELECT view FROM $tbl_name2 WHERE id='40'"; $result3=mysql_query($sql3); $rows=mysql_fetch_array($sql3); $view=$rows['view']; // if have no counter value set counter = 1 if(empty($view)){ $view=1; $sql4="INSERT INTO $tbl_name(view) VALUES('$view') WHERE … |
| | Hi all, I've been using this type of code to pull out a single value from my SQL database but I can't help thinking that there's a simple command I'm not using: [CODE] strSQL = "SELECT MAX(Stage) FROM Visits WHERE ScheduleRef = 22" FinalStage = dl.getPRISMdata(strSQL).Tables(0).Rows(0).Item(0)[/CODE] [CODE]Public Function getPRISMdata(ByVal strSQL … |
| | I really dunno wats wrong here. the firts query works but the second does not . please help... There a these connected files: save.php [CODE]<?php include_once("classes/jewelry/item.class.php"); $inum = $_POST['ItemNo']; $i=new item(); $i->ItemNo = $inum; $i->ItemName= $_POST['ItemName']; $i->CapitalPrice=$_POST['CapitalPrice']; $i->SalePrice=$_POST['SalePrice']; $i->Category=$_POST['Category']; $i->Description=$_POST['Description']; $i->save(); include_once("classes/jewelry/stock.class.php"); $j=new stock(); $j->ItemNo = $inum; $j->NumStored= $_POST['Nload']; $j->NumSold= …  |
| | Hello! I am making a simple web application with a database. I want to show all the members from a specific group. The group is selected in a drop down list which is populated from my sql database table tblGrupper. I have managed to populate a GridView with the groupID … |
| | Hi there guys can someone explain to me how I can increment a value within a field in my database each time I execute my query?. As I cannot seem to find a way to do this. Below is my structure for reading + writting to my database if you … |
| | Basically I'm trying to create an app where it generates random questions and displays them in a dialog box. I've managed to create a dialog box ok but incorporating the sql database full of questions and answers is proving difficult. I've been trying to follow this tutorial and it's the … |
| | need help here's code I'm almost finish I'm trying to find out how can i search down to the student who is taking at least two database classes here's the code [code] drop table student; create table student (student_id varchar(10) primary key not null, student_name varchar(10), major varchar(20), gpa decimal(10,1)); … |
The End.