2,569 Topics
 | |
| | I have a website for a painter where the painter uploads a picture. The picture name is added to a mdb (access) database table, the picture is added to the end of a table called galleries, and the file is uploaded. It is also then resized to a small image. … |
| | Hi Friends I am new to asp.net, i want to display menu title from database using VB in asp.net, the display should be done in list format while href tag, i am expecting the display as below menu1 menu2 menu3 Please can any one help me to solve this issue. |
| | I'm having a problem of displaying all the data of a column in a text file I can display only the first data, so please someone tell me what can I make to display them together in a text file. Connection con = DriverManager.getConnection(host, uname,password); Statement stmt = con.createStatement(); ResultSet …  |
| | So i have this table: numb_1 | numb_2 | numb_3 ------------------------ 5 | 5 | 5 1 | 5 | 5 2 | 2 | 3 5 | 3 | 6 5 | 4 | 7 how do i find the most common value in the 3 fields? so for … |
| | Hoi At the moment I'm learing Databases. this is some code that I'm using. The question that I have is, can I insert a row without ID. I mean that the database increase the ID number itself. Thanks in advance. command = new OleDbCommand(); command.Connection = connect; command.CommandText = "INSERT … |
| | I am trying to create a search form for my database where a user can search for a customer name and all of that customers addresses will be displayed. my structure looks like this Customer table + ID + First Name - Last name - Company Name Address Table + … |
| | |
| | Hi, I am writing a Silverlight Bing Maps based application and I am trying to merge two (and more) polygons. The approach I am using at the moment is the following: The geometry for the polygons is stored in a database, and Im writing and reading from it through a … |
| | I have a Query string > { "id": "105201322211272730088", "name": "Rayidi Radha Krishna", "given_name": "Rayidi", "family_name": "Radha Krishna", "link": "https://plus.google.com/105201322211272730088", "picture": "https://lh3.googleusercontent.com/-UTEdowBnUUE/AAAAAAAAAAI/AAAAAAAABd0/FrCv9VX1Pp4/photo.jpg", "gender": "male", "birthday": "0000-09-23", "locale": "en" } I want to convert this Query string to an array. thanks in advance. |
 | OMG Optimization.... One of those things that is widely discussed but with no real specifics because everyones setup and situation is different. So I spent all day trying to find ways to accomplish this as our SQL server was maxed out. Let me do a bit of setup explination.... We … |
 | Dear Daniweb members. I am having quite a troublesome time here with OleDb. What I am trying to achieve is to allow my users to connect to an uploaded Excel workbook, then to be able to select data from the sheets. I have a query designer in the front end … |
| | 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 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 … |
| | 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 …  |
| | 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 …  |
 | 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 … |
| | 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 … |
| | 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 |
 | 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 … |
| | 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 … |
| | hey there, Here's my complete code for a delete button that deletes a record in a Heirachical Flex Grid. Dim rsTour As New ADODB.Recordset Dim cn As New ADODB.Connection Dim strSQL As String cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=" & App.Path & "\Luckshan Tours & Travels.mdb;" & _ "Persist … |
| | Hi! I have table of records of my database. I have too many rows, so i decidet to add feature what i dont know how to call english, but mybe it's call page numbering. So i need split my table after some 10rows and its will make after table Paga … |
| | Hi, I'm new to PHP and I want to know how to prevent SQL injection? Any php features can prevent the SQL injection?  |
| | Hello Everybody please help me out i am in big problem the problem is my organization people gave me the WEB Application to edit it (the application was written in the C# language and it is web application so it is designed in ASP.NET MVC3 ) and i have to … |
| | Hello! I have few problems. I hope you will understand me and can help me :) 1st - I have large input form, so if i press sumbit button then it makes large query thats slows down my page and database is overload, in form is somewhere about 180 colums. … |
| | Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt … |
| | Okay, I know some of you are looking at that title and thinking I'm quite daft because obviously I have to have a dataadapter if I have a bindingsource. And you're right, there is a dataadapter, but it's not exposed to me. I've taken over a winforms project (attached to … |
| | Hi all, I need some help in how to achieve this functionality....the problem is ... I have some data in my database.On clicking 'generate invoice' , It should gather the data from the sql server and publish it to a document which the user can send it to a company.Basically … |
| | Hello,... i usually used win7 x32 bit and i use sql server 2008 r2 enterprice in it and there is no problem , but i change my windos and installed win7 x64 on my labtop after that i try install the same sql server which i used in this system … |
| | I've been doing some research about multilingual and recursive database design for few days. I found interesting the following article: http://www.gsdesign.ro/blog/multilanguage-database-design-approach/ and liked the 4th solution Coupled Translation Table Approach. But I'm seriously confused since I don't understand the case; I see there is only one column id on pages … |
| | I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that … |
 | i am having real issues trying to build a sql string Dim SelectQry = "SELECT * FROM TblSupplierQuotes where TenderNo='" & Me.txtTenderRef.Text & "' AND KMBPartNo=" & " " & Me.lbKMBPartNo.Text & " " in SQL the TenderNo is varchar(50) = L003141T75-2012JANTEN KMBPartNO is text = 442 019 115 1 … |
| | I am doing system using window phone 7 and sql server as database. I am using below coding to get shopping cart list at listbox. public List<Order> FindOrder(string custemail, string orderstatus) { var findorder = from r in order.Orders where (r.CustEmail == custemail && r.OrderStatus == orderstatus ) select r; … |
| | hi i need to show the last post thumbnail only i had the code but im now looking for code to get image i need to place the image on the top <ul> <?php $recent = new WP_Query("cat=1&showposts=10"); while($recent->have_posts()) : $recent->the_post();?> <li><a href="<?php the_permalink() ?>" rel="bookmark"> <?php the_title(); ?> </a></li> … |
| | Hi all, I am updating the position og pages, which I get dynimacally from the DB. It is d possible via the backend, for the admin of the site, to decide which position a page should have, when updating or creating a new page for the site. I let the … |
| | Hi everyone, In a nutshell...I have developed a site in ASP.Net and VB.Net which allows a user to create an order and submit it to a SQL Server backend database. When the order is placed...an xml file is also produced, showing the items that have been ordered...which is then loaded … |
| | Good day to you all, am currently working on a windows application. I used sql compact edition for the database. But the first problem i got was that it kept giving me errors i copied and pasted to error code on google and I got an article that says I … |
| | Hi, I have a problem in making a query.I have two tables patient and encounter. Patient has one to many relation with the encounter table. The encounter table has a field encounter_date. I want to make a search query in which I enter the date ranges and the query fetches … |
| | Im having a issue with comparing dates below is the code. it shows all rows even dates that have passed todays date. The Date field is set as date in sql. <?php $con = mysql_connect("localhost","myusername","mypassword"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydatabase", $con); $todays_date = date("Y-m-d"); … |
The End.