6,934 Topics
 | |
 | The application I am working on uses SQL to store data. Most of the data is fine the way it is, but one of the tables contains information that would be very tempting for some users to alter. My original plans were to have the application check the identity column … |
| | hi, i have records in table like this: id v1 v2 v3 1 587 21 759 2 230 4 495 now i want ouput like below: id v1 v2 1 587 21 2 587 759 3 230 4 4 230 495 i am stuck here don't know what will be …  |
| | Hi, I am new to programming and I am struggling with an sql select statement. I would really appreciate any help anyone can offer me! What I am trying to do is populate a textbox (using code and without creating a dataset) with data retrieved from an sql database. I … |
| | How do I change all greater than .00 cents to .49 cents be .00 and all greater than .50 to be round off? I'm using SqlYog btw. Example: price 1: 16:03 price 2: 16:53 Output: price 1: 16:00 price 2: 17:00 |
 | is it possible to use information input into one screen, then displayed into another screen using sql commands? this is how i am trying to get the information required: String sql = ""; if (cname.getText ().length () != 0) { sql = "SELECT CommonName, ScientificName,Type FROM Animals WHERE CommonName LIKE …  |
| | Hi guys just need a little help here. Well I'm done with the code but I can't seem to understand what's wrong with it. I mean when you are done entering your pair of username and password on both forms it's supposed to save the username and password entered on … |
| | Just came across [this](http://www.faqs.org/rfcs/rfc2821.html) (RFC2821) and in section 4.5.3.1 (Size limits and minimums) it states (emphasis added): > There are several objects that have required minimum/maximum sizes[...] > **local-part** > *The maximum total length of a user name or other local-part is 64 characters.* > > **domain** > *The maximum … |
| | Hi I'm a final year university student and i'm running into a bit of trouble with my final year project (It's very important) My task is to create a DBA (Database Administration) tool in visual basic to allow me to add/edit/delete users from an existing oracle(sql) database. I really don't … |
 | HI. I have a situation where we need to pull data from multiple data sources into one dataset. Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable … |
| | Hello all, Correct me if I mis-post or should have posted this somewhere else. This is my first thread here so bear with me. I have had a lot of luck just browsing other issues to get my problems solved in the past, but this time I am stumped. More … |
| | Hi All, here's the query.... $risk_section=$row_risk_category['risksectid']; mysql_select_db($database_auditing, $auditing); $qry_selfsites = sprintf("SELECT tblself.siteid AS selfsite, tblsite.sitename AS sitename, tblsite.address AS address, tblpct.pctname AS pctname, tblresultsnew.total, tblresultsnew.auditid AS auditid, tblriskcategories.risksectid AS risksectid, tblriskcategories.risksection AS risksection FROM tblself LEFT JOIN tblresultsnew ON tblself.auditid = tblresultsnew.auditid LEFT JOIN tblsite ON tblself.siteid = tblsite.siteid LEFT …  |
| | |
| | I am using mysql to fetch this result from the database.I need to caluclate the rank of a prticular user id from this result.What is the easy and smart way of doing it? SELECT a.UserId,d.AreaId,d.SubjectId, SUM( a.Marks ) AS sum, COUNT( a.Marks ) AS count, SUM( a.Marks ) / COUNT( … |
| | Hi guys I'm just starting to built dynamic php site but while testing (pasted url/embed) videos from youtube I get this error. 403 Forbidden Access to this resource on the server is denied! I use a form to post to the database. It works for everything else except embedded video … |
| | Hi all, I'm newbie in asp. I have a problem to delete the record on sql. I have one form for different users to insert data into sql where every user have are unique id, so it's possible to have multiple record with same unique id, then display the data … |
| | protected void Button1_Click(object sender, EventArgs e) { try { SqlAddGroup.InsertParameters["mem_email"].DefaultValue = Session["User"].ToString(); SqlAddGroup.InsertParameters["groupname"].DefaultValue = Txtgroup.Text; SqlAddGroup.Insert(); Label1.Text = "Group has been added"; } catch (Exception ex) { Label1.Text = ex.Message; } } <asp:SqlDataSource ID="SqlAddGroup" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:PadmaSMSConnectionString %>" DeleteCommand="DELETE FROM [group] WHERE [sno] = @original_sno AND [mem_email] = @original_mem_email … |
| | With both subs you must enter the values as you would write them into a sql string i.e. 'mustsurroundstrings' I'm rather new at VB.Net and SQL but these work for me and are seem pretty efficient. If anyone has a way to improve on them or finds a flaw in … |
| | Eventually i want to load names from a database to textboxes which are created at runtime. Thought i'd try just getting names into a listbox first though as i'm new to using databases in vb and for some reason nothings getting added to the listbox Heres the code iv'e got …  |
| | i was wondering how can database replication on a sql server be accomplished? |
| | Hi friend, i am trying to learn ASP but i face problem to connect ASP wtih SQL Server. Anyone help me. Sushil .. |
| | how to delete duplicate record in a table by using SQL query |
| | Hi I am basically designing a database to store our development team metrics...here are some of my tables. What do you guys think? I am having a lot of trouble coding this on SQL Server so that question is asked towards the bottom :). ProductTable: productID (PK) productDescription SprintTable: sprintID …  |
| | ok, I have what I hope is an easy problem to fix. i'm try to query a db, store to a temp table, and then query the same db, inner joined with first query. please help. I'm currently getting "access cant find table/query" error. I've tried putting quotes around tmp, …  |
| | Hi, i am trying to learn how to create login and register page on my own. But i am having any luck with it. can any one help me from start to finish? and by start to finish i mean just the login, register and database part, not the whole …  |
| | Hi Everyone, I am facing the following problem: My connection to SQL Server 2000 (Enterprise Edition with sp4) is fluctuating a lot. It gets disconnected after one or two hours and remained so for 2 - 3 minutes and again re-establish or sometimes I need to restart the SQL Server … |
| | Dear Expertise, I am problem with coding to search the data from database using stored procedure and vb.net form. I am coding with vb language not the C#. Explanation: I have stored procedure named "usp_GetPayByGrade" : /* Name: usp_GetPayByGrade Description: Search the Record to dbo.hrGradePayScale table by gpsIntGrade Author: Tashi …  |
| | how to drop multiple columns at a time.. i tried with the following syntax "alter table <table_name> drop column <col_name1>, <col_name2>" but i am getting syntactical error. |
| | can we use double quotes to the column name while creating a table?? if yes, then how to insert the records into it??? |
| | Anybody have manage to install PeopleSoft HCM9.1 or other 9.1 module using SQL Server 2008 or R2 on Windows 7 OS on their laptop? If yes, please provide the steps and details specially input param for each steps. Also include installation of SQLServer and details including configuring Data Sourse/SYS DNS. … |
 | Can you perhaps tell me why I'm getting this error? I'm trying to upload a image to a database through php and I'm getting this error the whole time in my picUpload.php These are the errors I'm getting: [CODE] Warning: move_uploaded_file(avatars/beetgejo.jpg) [function.move-uploaded-file]: failed to open stream: No such file or … |
 | Hello Friends, Can anyone tell me how to find the list of SQL servers on the local machine...and not the network... I searched in google but everywhere its for the list of SQL servers on network....I just want my PC SQL server name.... Is it possible to get it? Thanks … |
| | I have tried using the following it saves the data but the data is not visible in database i have attached the Screen SHot of the database below. i am pasting my code below. Kindly help me out as m not getting what to do further.  Private Sub … |
| | Hello all, How many ways are there to put variables into a query? The reason I ask is that I cannot get "SELECT * FROM locations WHERE title LIKE '%".$input."%'"; The "SELECT * FROM locations" query only does give me the full table but using that input variable substitution (from … |
| | In my script, I have a table displaying the results of a SQL query. However, I am using the results as a sumamary, but the SQL is making the page display the table as many times as there are results (rows) in the returning SQL that are allowed because of … |
| | hi, i'm trying to do some appointment book so i decided to use MonthCalendar control and date changed event for choose the date i tried dataset.table.rows.find() function on other tables which have int primary key and it works its finds my row/s i need but when i tried this func. … |
| | Dear All, I want to create a dynamic website with a database. Visual studio 2010, dreamweaver CS5, sql server management studio and all other requirements are installed (like IIS 7). I set the IIS server configuration in dreamweaver cs5. I check simple ASP codes like <%Response.Write ("The time on the … |
| | hoi I would like to learn how to work with databases. does anyone know a good tutorials or sites? because at this moment I know nothing about it. thanks in advance |
| | HI i am getting error on lbl.Visible = true and command.ExecuteNonQuery(); plz check and paste correct coding i doing new project plz help me. protected void Button1_Click1(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=RAVI-PCSQLEXPRESS;Initial Catalog=personals;User ID=sa;password=sa;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(" select * from table_2", conn); … |
 | I currently have a client who came to me asking me how to build a system for him where he can give varying levels of discounts to events based on the number of people who get referred via a unique affiliate link/cookie. The key stumbling block for this project isn't … |
| | Guys, current im using MS SQL 2005. today they will change it to MS SQL 2008 express edition. My question are: 1. can I still create SSRS/SSIS. 2. i have existing RDL,RDS file. still can open it to 2008 express. Thanks. Jonel  |
| | Hi, We have an SQL Server 2000 with one 138GB database currently used. I am worry of the performance because as time goes it becomes slower and slower. So I tried googling out the solution and I found out the DBCC Reindex command. As what I read, first you have … |
| | Hello, I'm still working on project filter SqlDataSource with parameters. 1.Button1 is my first develope code which is working fine with Dropdownlist controls. 2.But, now I want to move to filter with Checkboxlist items. I have write code under Button2_Click event. I have combine codes of my current knowledge which … |
 | Hello, I want to change the datatype of a field from Varchar to integer in T-SQL. I tried something like Modify like you use in Oracle. ALTER TABLE tablename MODIFY COLUMNNAME Datatype. But its not working in SQL server.. Any thoughts. |
| | I'm bit new to SQL server Express edition. I'v create few databases using sql server management studio. (always i login as windows authentication mode). Those databases are working properly with VB.net. In those databases i've never used username and passwords. But now i want to login as 'SQL Server authentication' …  |
| | Hi this is my delete.php <?php $con = mysql_connect("localhost","matanc_cmd","123123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("matanc_cms", $con); // check if the form was submitted // get the ID (cast it to integer if it is supposed to be integer) $id = (int) $_GET['id']; mysql_query("DELETE FROM content …  |
| | Hi i am Trying to delete a page from my site cms and something is not working . the code is: <?php $con = mysql_connect("localhost","matanc_cmd","123123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("matanc_cms", $con); $id = (int) $_POST['id']; mysql_query("DELETE FROM content WHERE id='$id'"); mysql_close($con); // if successfully … |
| | Hi! I have small problem, in my add.php is selection tag used to choose year, so in my edit.php has place for year too where i use selection tag too, but how can i show in edit.php that year in selection tag, that what i have choosed in add.php? With … |
| | Hello, I have to appologize but I am very new to programing and web developemnt. I have developed a web site that will allow users to register and store their info in an database. I am using webmatrix to put it all together. I have no problem adding the info … |
| | Hi, I have a sql statemente but I don't want to display all info in the gridview (c# webforms). How to bind specific columns at runtime on gridview? Thanks |
 | I was wondering if there is a way to open an SQL file and execute it from a c# application without prior connection to a database and also get the name of the default server that is used when SSMS is opened. at the moment i can open SSMS but … |
The End.