6,934 Topics
 | |
| | 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 … |
| | Daft subject header, but its early and brain not awake yet! One for the SQL gurus (either that i've missed something here....lol) I want to select rows where there are duplicates of data in some columns, but not others. Where a duplication IS found, i want to return all rows … |
| | 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= …  |
| | Proper way of doing this? Please disregard some variables. [CODE]Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types Public Class Addcage Dim conn As New OracleConnection Private cmd As OracleCommand Private da As OracleDataAdapter Private cb As OracleCommandBuilder Private ds As DataSet Dim roomprice As Integer Dim roomtitle As String Dim lubid As String = …  |
| | Hello Guys, I really need your ideas on this one... Ok, I'm only familiar with php and simple html coding. I'm designing simple book loan database. Consist of two sql tables (a very simple one) table 1 book_in table 2 book_out Ok.. Let say, every book is determined by a …  |
| | 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 … |
| | sql SP ALTER PROCEDURE arunsss @suppid VARCHAR(50), @suppname VARCHAR(50), @dispname VARCHAR(50), @exists bit output AS SET @exists=0 BEGIN IF EXISTS (SELECT suppname from [supp] where suppname=@suppname) SET @exists=0 ELSE BEGIN if(@suppid is null) begin select @suppid= isnull(MAX(convert(int,suppid)),0)+1 from us.dbo.supp where ISNUMERIC (suppid)=1 end INSERT INTO [us].[dbo].[supp] ([suppid] ,[suppname] ,[dispname]) VALUES … |
 | I was hoping someone might be kind enough to throw some advice my way on this one. I am using stored procedures to perform many of the queries for my application. One of the reasons I chose stored procedures was for security. Because I would like to make the application … |
| | Hi guys, i am currently working on a project that queries an inventory database through the use of radio buttons, for example; If the first button FOR THE Item(HAMMERS)is clicked, the output should be the name of the item, the number sold and the total profit(calculations) into a table. the … |
| | hi every one i wanted to get some information on how to insert data into sql server through combo box selection. i have 2 values in combo box. 1 is admin and 2nd is employee. basically its an employee registration form. could any 1 help me if during registration the …  |
| | I have a sql table for storing unique e-mails.I need a stored procedure that could let a user that uses aspnet page to insert data know that the e-mail address already exists on a table and specify a new one. The table looks like this: EMailID int NOT NUL (1,1), … |
| | hi, i get this error when i run my script [CODE]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\xampp\htdocs\autogh\admin\userindex\scripts\banner.php on line 13[/CODE] this is my mysql statement [CODE]$banners_num = "select * FROM banners WHERE DATE_ADD(todate, INTERVAL numDay DAY) > NOW() AND position='top_banner'"; [/CODE] Am trying to … |
| | hi every one i am trying to save data from vb.net form in sql server 2008 below is the code which i am using but the only problem is . i am not getting any error instead the data which is being saved in sql server in my First Name … |
| | 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 … |
| | hi every 1 i am trying to make a search form . i want to display the data saved in sql server in a grid view upon hiting the search button . below is the code which i am using but i am getting an error > Conversion failed when …  |
| | hi every one. i am making a booking app in vb.net and im using sql server as my database. i am confused about table creation. I have increment of 1 in customerid which is primary key in customer table. Suppose if a customer books a room and according to the … |
| | 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)); … |
| | Hi All, I am hoping to finish this feature on a shopping cart soon - just one thing im not sure how to create. Basically: 1 hour after a user has put the very first item into the shopping cart - (items are stored in the database) I want to … |
| | Hi Guys well what I want to do is instead of within my writeString to set my PLAYCOUNT to '16' what I want to do is every time the statement is executed my PLAYCOUNT is increased by 1. Any help you can give would be appreciated: My code is below: … |
| | I'm hoping someone can help me out with this. I have a datatable populated from an SQL Server 2008 database table. I created a DataAdapter with a commandbuilder to manage the updating, inserting, and deleting of records. The Updating and Inserting work as expected. However, Delete does not. The code … |
| | Hi there, I am relatively new to PHP and MySQL coding and I am currently using the Joomla CMS. What I am trying to do is get a game name based on a custom field value from my DB like so; [CODE] // fetch the value of field called Game … |
| | SQL = "SELECT * FROM tbldes WHERE Category LIKE '%" & Replace(Trim(Text1.Text), "'", "''") & "%' ORDER BY category" rs.Open SQL, cn, 2, 3 use of this sign(%) anybody can explain me, what is the use of this code? br |
| | I have Sql query consists of multiple tables in ms Access database(has Join Right/inner join) and I would like to insert and Update data on it using ADO.NET. I would be most grateful if someone could provide me with a clear example. Thanx |
| | Hey guys!!! (and gals)... Uhhmmm... I'm in a bit of a tiffy... Im trying to populate a drop down list with data in my query browser. But I AM NOT USING JAVASCRIPT...mostly because i havent learned it...but im trying to a certain table from the query browser to my drop … |
| | Hi, I am using a Dynamic SQL to create a stored procedure. The stored procedure is as follows: [CODE]CREATE PROCEDURE spRetrieveBalanceSheet (@Pfcode varchar(5), @period varchar(10)) AS BEGIN DECLARE @tablename varchar(12), @sql varchar(2000) SET @tablename='SALFLDG'+Upper(@Pfcode) SET @sql='SELECT S.ACCNT_CODE As Code, SUM(S.AMOUNT) AS Amount, A.ACCNT_NAME AS Name FROM '+ @tablename + ' … |
| | Hi, I am creating a form application that should display information from one dataset into individual textboxes (ie. system name, system id, location name, location id). The textboxes populate upon the selection of a pair of cascading combo boxes. So, the user first selects a system name from the first … |
| | hey, I am totoally window person no experience with apple whatsoever except it is a multi-touch mouse that I know say -- if I wanna to learn android, I start with appinventor.com ----- I really wanna to learn write an apps for ipad i.e. business application I want it to …  |
| | Cannot connect to x. =================================== A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 …  |
| | Is there a workaround to this as decode does not seem to allow the use of greater than equal sign I am trying to show the comment for any days beyond 4 days, not just 4 days. [CODE] decode(shipdate-orderdate,'4','This is unsatisfactory!') comments from orders [/CODE] Thanks in advance! :) |
| | i have a problem with sorting this thing... i want to sort a column without changing the data in the other column. i have an attached document. a picture of my query and database.. tnx :) |
| | Hi guys well I have a problem on my JFrame which is once I click on my List all Videos button it displays my data from my MS database which all works well. However as you can see from the png the query results are not aligned up correctly together …  |
| | There is a sqi vulnerability in my client website. I cant give you the links but can you guys suggest how to avoid it.  |
| | Im creating a project where the a blog can be submitted, the date is stored in the database as dd/mm/yy, however im using LINQ to SQL to get the date as well as other information, the problem comes when i want to display the date in a particular layout (similar … |
 | Hi, I'm using SQL Enterprise Library (Microsoft.Practices.EnterpriseLibrary.Data.Sql) objects and I'm considering using a DbTransaction to execute multiple DbCommand(s) for inserts/updates in one transaction. Let's say these queries take a few minutes to execute, I do not want it to prevent another process from queries the same tables. Considering I do …  |
| | Hi Everyone, I have been trying to understand mysql a little further - with some small steps in the right direction. but I have come across a problem I am unable to fix / get working. I have a form, that has a variable $country - I am trying to … |
| | I am trying to figure out some web development using ms vwd in C#. I want to link a couple of textual titles to hyperlinks. However, those hyperlinks are stored in a database object's column using ms sql server and so I need to use the oledb commands and iterate … |
| | Hello. I need some help in solving a php code project. I have a combo box field (months) that pulls all 12 months from a MYSQL table. The combo box is populated using php. I want to know how can I evaluate the value in the Select tag to do … |
| | Hi, I'm creating a form application using vb. I'm still new to this and I'm teaching myself via the internet so please don't be too mean. I wrote my code using queries that I created in visual studio. I don't quite remember how to create an update query and write … |
| | I asked this basic question a couple of days ago but I probably didn't include enough information in my question. Sorry for reposting, but I am really lost here. This is a web application in VB.net connecting to an Access database on a 2003 server. The problem: I have a … |
| | Hi, I have a windows form with a "ComboBox" on it. The "ComboBox" has the words "Production" and "Development" in it. If the user selects "Production", I need my C# code to point to the Production database. If the user selects "Development", I need my C# code to point to … |
| | hello ! i am working on an application and i want to connect it with mssql database , i dont know about the version of installed mssql server at the pc , how can i get the version of installed mssql server so that i can connect my application with …  |
 | Private Sub autocus() Call main() Con.Open() Dim cmd As New SqlCommand("SELECT cust_order FROM Inventory", Con) Dim ds As New DataSet Dim da As New SqlDataAdapter(cmd) da.Fill(ds, "My List") 'list can be any name u want Dim col As New AutoCompleteStringCollection Dim i As Integer For i = 0 To ds.Tables(0).Rows.Count …  |
| | im a beginner wid vb .net and need to clear the air wid connecting a database file created on sql server 2008r2 wid vb.net 2008 for a project..plz nebody help from scratch regardng retriving,insertng n modifyng data using vb.net code..awaiting.... |
| | Hi everybody, I found an error-based sql injection in my webserver.My database doesn't contain any private info. I want to know if its possible to own my server just by using the info in information_shema. Please tell me because i want to know if i have to fix it.I don't … |
The End.