6,934 Topics
 | |
| | 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 … |
 | I an developing a Multilevel Marketting Website. I have enterd data in sql table (MemberDetail) columns(Member_Id, LeftChildMemberId, RightChildMemberId,TreePosition). Now in asp.net form I have to display Member_Id in form of Binary Tree. How can i do this?  |
| | I am using VB6 to execute an sql statement. I have two access tables and want to insert the contents of a field in one into the other subject to the key no being the same. I have been unable to get it to work and would appreciate some help. …  |
| | 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 … |
| | hi i need to save rss to sql every day first load read and write sql and other read from my db Imports System.ServiceModel.Syndication Imports System.Xml Imports System.Data Imports System.Data.SqlClient Partial Class _Example4 Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim RSSReader As …  |
 | 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 // …  |
| | Is it possible to have a auto-tracking event or something similar to track the database when it changes? For an example: If the database gets a new insert value from another application that I currently have: then My other application will notice it and fetch that data instead of getting … |
| | |
| | Need some help here. I was trying to make a Stored Procedure in MS SQL 2008 which will make use of comma delimited string as Parameter in my WHERE [COLUMN] LIKE [PARAMETER] condition. Somehow, I was able to select rows of data from my DB table that matches the set … |
 | 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 … |
| | |
 | hello folks. i have saved the values of unique_ID.text textbox1.text textbox2.text textbox3.text textbox4.text textbox5.text textbox6.text in columns column_ID and column_1 to column_6 in a table table_1 in database db_1. Now I want to update some values. but for that i want to show the values of column_1 to column_6 in … |
 | Group, I may have made a huge mistake repairing SQL Server Management 2008 Express. Here are the details: I'm running Windows 7 on a Toshiba Laptop. SQL Manager 2008 had been installed and was working fine. I had some registry errors popping up, so I ran ARO 2013 to do … |
| | 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(); … |
 | Good day folks, I want to delete some records in my datatable using query. But I don't know how to do it. Can someone help me? Thanks For i As Integer = 0 To objChkArray.Count - 1 Dim rows As DataRow() = dtable.[Delete]("ct = '" & CInt(objChkArray(i)) & "'") For … |
| | Hi I'm a newbie in SQL and for scores whose credit is greater than 2, I want to select students with scores of 10 or more .Here is what I wrote and Im having errors(See table below): SELECT Student,COUNT(Score)>=10 AS NumPasses WHERE Credit>2 GROUP BY Student Student Credit Score Tomy …  |
| | I am creating PDF's using ITextSharp and Stored procs. I have a stored proc in place that calulates the totals of two columns SELECT SUM (Time) AS TotalTime, SUM (Cost) AS TotalCost From dbo.Records WHERE CustNum = @p_CustNum When i run the stored proc it returns the two answers. However … |
 | 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 … |
| | i want to access (Add, Delete, Update) data through lan (local area network)using vb.net looking for the connection string to access the same. Saurav  |
| | 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 … |
| | sql 2008 to vs 2010 add edit dele update save report serch filter codes help namn po..kelngan ko po sa project ko..tagal q na naghahanap sa net putol puyol nahahnap q..hard code mas ok..thanks |
| | |
 | $accname =$_POST['uaccountname']; $aid =$_POST['aid']; if($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['submit'] =='update account') { $qry = "UPDATE accounts SET acc_name = $accname WHERE acc_id =$aid"; mysql_query($qry) or die(mysql_error()); } it gives folling error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for … |
| | hi i am using visual studio 2008. and sql server 2005. now my doubt is how to connect the mdf in asp.net application with C#.??? am using design in web form in asp.net applicaton with C# can any body ask ??/ how to connect the database and how to connect … |
| | I have two stored procedure but when i call two stored procedure then given error comes: "Warning (512): SQL Error: 2014: Commands out of sync; you can't run this command now [CORE/cake/libs/model/datasources/dbo_source.php, line 684]" i'm using cakephp. And my code is: $city=$this->City->query('call CityMaster_SelectCityName'); $allAgents=$this->Admin->query('call WorkForceLoginMaster_SelectLoginName(0)'); What i do any simple … |
| | **I have a form Upload.aspx** <%@ Page Language="C#" AutoEventWireup="true" CodeFile="CSharp.aspx.cs" Inherits="_Default" %> <!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 runat="server"> <title>Upload Files To DataBase</title> </head> <body> <form id="form1" runat="server"> <div> <asp:FileUpload ID="FileUpload1" runat="server" /> <asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" /> <br /> <asp:Label ID="lblMessage" runat="server" … |
 | I have this code and it outputs buttons that goes down. I want them to go horizontally. please help. T_T <?php $var=1; while($row=mysql_fetch_array($che… { ?> < action='' method='post'> <input type='submit' name='view' value="<?php echo @$var ?>"/> <input name="workId" type="hidden" value="<?php echo $row['workId']; ?>" /> </form> <?php $var++; } ?> I don't … |
 | hi all! i have here a code to delete a record <?php define ('DB_NAME', 'vincegac_vince'); define ('DB_USER', 'root'); define ('DB_PASSWORD', ''); define ('DB_HOST', 'localhost'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db(DB_NAME, $link); if (!$db_selected) { die('Can't use ' . … |
 | hi we have an office chat messenger in our office, it is executable, and ofcourse cannot modify the codes already. i dont know exactly how this messenger save history, looking from its root folder, i cant see something related from its conversation or message history. I just need to save … |
| | hi, how to convert db table column datatype from varchar to binary(16) in sql server 2005? thanks  |
 | This php code updates a database entry. The form consists of a checkbox (name = download) and a hidden field so I can check it has actually been sumbitted(name = updated). When I run this code it gives me the success message but the database remains unchanged. Why is this? … |
| | I have a snippet of mysql which is filled in with two variables: SELECT `download` FROM `images` WHERE `owner_un`='$owner' AND `url`='$url' The `$url` variable comes directly from a URL variable. This input should only ever contain alphanumeric characters, if this helps. Thanks for any help |
| | as title itself is saying what i am looking for over here. I formatted my pc and installed Sql server 2005. I detached db before formating the system and attached after formating. however after attaching i am getting Db in recovery/ readonly in object explorer. I tried to change properties … |
| | I am having a little difficulty witht he syntax of a lookup using access DB here is the code: "SELECT * FROM tblContacts WHERE ContactID IN (353,1520,2031); Order by ContactID" It works find without the order and I have tried without the ; or with the ; at the end, … |
| | Hi All, i have requirement like to Convert rows to columns in SQL server. i have retrieved data like below: MatchId SelectionName Odds 322 Home Win 1.33 322 Draw 5.00 322 Away Win 9.00 322 Under 2.5 2.40 322 Over 2.5 1.53 and want to convert like below: MatchId Home … |
 | My Laptop Specs: **i3 2.40Ghz 2048MB RAM Sony VAIO E Series Intel(R) HD Graphics 4000 64-bit OS** I had tried installing **Microsoft SQL Server 2008** for about 3 times now on my laptop. I still can't install it. Please help me. What to do? I really need the software for …  |
| | Hey all, Sorry if this is really simple but I couldn't think how to phrase what I'm looking for on google. I've designed a piece of software for a friend for their business. When I learned VB we were always taught how to use it with Access Databases. I've decided …  |
| | I am trying to create a form that allows the user to search (Access database) for a record by last name or customer number. It can be a partial last name or customer number. The SQL statement and code are below. This is the same method used successfully for a … |
| | hi i am new to sql i want to get some values from different tables and i have made my own logic like that "SELECT course_name, course_id FROM tbl_course WHERE course_id = (SELECT course_id FROM tbl_enrollment WHERE student_id = '" + lbl_StudentID.Text + "')" what could the correct sytax for … |
| | what's wrong with my code at line 6, it's give blank page, the output can't display. $kp = $_POST['kp']; $kp2 = $_POST['kp2']; $kp3 = $_POST['kp3']; require("conn.php"); $sql = "select * from pemohon where kp_baru='$kp' AND kp_baru2='$kp2' AND kp_baru3='$kp3'"; |
| | ok here is the login function from my class user which parent class is a Db connection file <?php require_once("DBConnection.php"); class User extends DBConnection { .... .... ... ... public function Login() { $sqlSelect = "select `UserName` from `user` where `UserName` = '$this->userName' and `Password` = '$this->password'"; $result = @mysql_query($sqlSelect, … |
| | please help me. i connected two system using a cross over cable, and was able to see the remote servers in both systems but i am experiencing a connection problem to the remote computer. how do i connect to the remote sql database server? and how do i replicate between … |
 | Hello all, I was hoping You could help me with this. The code below is for the login screen in my project. the data is selected from UsersList (UserID,FirstName,LastName,UserDOB,UserUsername,UserPassword,UserAdmin) What way can I modify the "cmd" command to check if the value for UserAdmin is true and display a message … |
| | Group, I've written a short stored procedure in SQL Server 2008 to create a new Order Number. The code looks like this: INSERT INTO ORDRNUMBERREC(OrderNo,UserId,CreateDate) SELECT MAX(OrderNo)+1,'system',GETDATE() FROM ORDRNUMBERREC WITH (TABLOCKX) In VB2010, I've written the following code to execute the stored procedure: con = New SqlConnection(sConnection) cmd = New … |
 | Hello. I am having a bit problem with the insert query, Every thing is fine but don't know why its not inserting the queries. Have a look onm code; function insert() { var table=document.getElementById("myTable1"); var table=document.getElementById("myTable"); <?php $con=mysqli_connect("localhost","root","","bsc_db"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: … |
| | i want to redirect my query base url to pretty url,i am trying this on local host, i want if any one try to access http://localhost/something/index.php?page=zen it will redirect to http://localhost/something/zen.html, ie http://localhost/something/index.php?page=zen => http://localhost/something/zen.html RewriteEngine On RewriteCond %{REQUEST_URI} ^/index\.php$ RewriteCond %{QUERY_STRING} ^page=([a-zA-Z0-9_-])$ RewriteRule ^(.*)$ http://localhost/cmsmadesimple/%1.html [L,R=301] |
 | I have to make a database system that is purely on SQL Server. It's about a diagnostic lab. It should contain at least 40,000 distinct patient records. I have a table named "Patient" which contains an auto-generated ID, Name, DOB, Age and Phone number. Our teacher provided us with a … |
The End.