2,569 Topics
 | |
| | I'm trying to restore previously backup text file into sql server on specified database. Could it be possible using VB.NET? if possible please help me.. |
| | i'm using VB.NET AND SQL SERVER AND HAD PROBLEM TO RESTORE PREVIOUSLY BACKUP TEXT FILE. |
| | hai all, i am working on a project, my project have 3(bronze, silver, gold) types of payments, payments are done through the paypal the expiry date is one month. if user reach the expirydate we must send email to him, after expirydate is passed his payment type change to bronze(it …  |
| | Ok I am currently learning php through wordpress and I have a small project to create a running website which displays the results. CUrrently I can display the results for a certain race that I hard code: [code] <?php // Connects to your Database mysql_connect("XX.XX.XX.XX", "admin", "pwd") or die(mysql_error()); mysql_select_db("db") … |
| | Hi there, I’m very new to ColdFusion and I’m still going through the learning process. I have a report to create in CF and I don’t know how to start: I have three tables in 2 databases: tblEmployeID with EMPLOYEEID, EMPNAME, MGRName (this is in SQL 2000) tblCategories with CODEID, … |
| | i want to display a selected record from my database to the data report in VB6. i used the foll. code, where cuno is the value of a textbox. i m passing the value of cuno through a module. SELECT * FROM Bill WHERE ID=cuno but when i run it, … |
| | I hope you can help me. I'm working on a program that will open any Access database that might be on the system. The problem I'm having is that I cant get get the SQL statement to show all the tables within the database. The code im using is as … |
| | HEy everyone. I've been workign on this for a few days now and it's due tomorrow, so I thought I would ask a developer community for any input. Here is what is supposed to be happening. The Server starts. The Client Starts. The user enters a table name into the … |
| | Plz help me out to resolve a conflict. I have made untiring efforts to resolve but coudln't. I have showed my data in gridivew now in windows forms now i want that when i make chages on the gridview using it like an excel sheet. These changes should also be …  |
| | [code] try Dim da As String = "+100acs+" Dim con As SqlConnection = New SqlConnection("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts; Integrated Security =True") Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("Insert into sales_details (bill_number,product_id,quantity,rate,amount) VALUES ('" + da + " ','" + Ddpproducts.SelectedItem.ToString + " ','" + Textquant.Text + "','" + Ddpproducts.SelectedValue + "','" … |
| | Allo all, I'm using a DataSet to collect a random comparison from a database, and then passing those values to Public Variables, then constructing two Insert Statements (which shows on screen, and is valid). With the [B]two Insert Statements[/B], I'm using two buttons (in an ASP.NET Page) that Call a … |
| | Hy, I seek your help in solving the following problem: I have a select which returns columns like ( without count_same which I need to create by counting the same name): ID | NAME | no_items | count_same ----------------------------------------------------------- 1 | A | 1 | 2 2 | A | … |
| | [B]Hello everybody, hello Dani:icon_cool:![/B] I'm doing my homework of 'Data Base', exactly in the chapter: Relational Algebra, here I am, I can't find a specific relation (or the SQL corresponding query) :icon_confused:! Here the schema: [COLOR="Green"]MEAL(guest,date); MENU(dish,date); PREFERENCE(person,dish);[/COLOR] I wanna find the SQL query (or the relation in Relational Algebra):[COLOR="Green"]"the … |
| | Hi, i've tried several times, but haven't succed in making this: Classroom2 Name: | Date: Oliver | 12-10-10 Homer | 12-10-10 [COLOR="red"]Peter | 11-11-10[/COLOR] Classroom1 Name: | Date: James | 20-10-10 Lars | 20-10-10 [COLOR="red"]John | 11-11-10[/COLOR] How do i make a SQL statement that ONLY selects the lastest dates … |
| | I'm just going to post my pages here if someone will take a look and let me know where to go from here...sorry, I could have attached files if you would prefer. I am not sure what needs to be in my VB page if anything more is required nor … |
| | Well I am interested in fetching 3 records because i need to show them on one screen as the program starts, and reason for showing 3 recording is to maintain next , now and previous button. Whenever i click next button so it should increment by +1 everytime and show … |
| | Hi everyone, This is the error i am getting when i try to do SqlCommand.ExecuteNonQuery(). My application runs on multiple threads and constantly opens, executes and close connection. This error i am getting after running the application for some time. Error: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results … |
| | hi - i have coded a seacrch box and its results are displayed in a tabular form. i have also a print button which when pressed shud create a pdf based on that table that is displayed. for this i have a separate page called pdf.php. i am using ezpdf … |
| | hi all im looking to use a select mysql query - but im trying to query the database against a users logged in sessions. I have the sessions working correctly but I am unsure how to included the session data in my sql select query. here is my users session …  |
| | Hi, Does anyone know how i can AutiFix (ie check that all tables and primary keys are setup) an SQL database? A company i was working for a few years ago had this facility on their software and i was really handy. Daniel. |
| | Hi, i'm not sure this is in the right place but here goes: I'm currently using ADO in VBScript to access a SQL Server database and one of my current issues is returning the full error message that a stored procedure generates. I can get a brief error description and … |
| | Hi there, I am making (more like, have already made) an IRC bot in Java. I would like to be able to query a shoutcast server with my bot and return basic information (such as now playing, bitrate, etc). I have scoured google and only found php code which i … |
| | Hi, In C#, i got sql Exception which consists of 2 lines. I need only the 2nd line of that Exception only. Ex: The transaction ended in the trigger. Table Validation failed - Name: x; Condition: m!=0 i need "Table Validation failed - Name: x; Condition: m!=0" only. I have … |
| | hi, Question 1 i am developing a project in C#.Net, and when a form loads data from the SQL client database is added to four combo boxes in the form, i need to change the data in the combo box when the check box is ticked. I wrote a code …  |
| | hi, i am doing a project in C#.NET desktop application. how can I make a upload, retrieve functionality in C#.NET desktop application for pdf documents, I am using a sql client for the moment, so i need to upload the file(file path, content, title in to the database) how can … |
 | Does anybody have any ideas of how to make an advanced search function? I would like to accept a string as the search query. i want it to run a query on the string as a whole, and for each word in the query. The problem is here: The results … |
| | hi........ can anyone tell me the connection strings to connect JAVA JAPPLET to sql server 2005 database and also the execution of SQL statement in java thanks  |
| | Hi, I have [code] SessionData sdc = new SessionData(); [/code] And all the properties of sdc are stored in a table in sql server. I want to retrieve the properties of the sdc dynamically. And i know [code] sdc. reader1["xmlname"]= [/code] is a wrong way of doing it. So can … |
| | Hay, I had a question about a login system that i want to create. I have SQL express 2005 with value's ( business name, passwords e.d. ). This system we use to fill in what we did at the company, and how much time we spend on it. This system … |
| | Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … |
 | Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to … |
| | I posted this on Oracle Forums to the sound of crickets chirping. This question entails more Oracle specific tasks then java but since my code is in java, here goes" Hello, I have a java package where I am attempting to implement a database Change notification registration and listener. I … |
| | Hi, I’m going to calculate a ratio between two entities but are having some trouble with the query. The principal is the same to, say a forum, where you say: A user gets points for every new thread. Then, calculate the ratio of points for the number of threads. Example: … |
| | Hi there, I'm a beginner in ASP.NET with VB and I'm stuck on problem with a SQL query. I'd like to ask you for advice what does my page or config file miss. thats how my form looks like [CODE] <form id="form1" runat="server"> <div style="margin: 0 auto; width: 180px;"> <asp:Label … |
| | So, I've been trying to get a page to update items in an MS SQL database forever now, trying different methods here and there having nothing working. I finally got one method to work using a datagrid thing, and it's fine for the test table I'm using. But when it … |
| | Hello I have a rails application where I have to subtract 2 time stamps and display the result on the webpage I have used the following sql statement and I am getting the results. [CODE]select (julianday(resolutions.created_at)-julianday(tickets.created_at))*24 from tickets,resolutions[/CODE] the value of tickets.created_at is 2010-04-05 18:59:02 which is a time stamp … |
| | I want to raise an event in C# when any one user make an insert or an update to a certain table in SQL server via my C# program. As there are multiple users using the execution file in various locations, I can not do it using the C# cord … |
| | hi i want to insert a textbox value into one column of a table. bt wht i m getting error as: Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '{'. the code is [CODE]SqlCommand comm = new SqlCommand("insert into Sample {'email_id'} values("+ TextBox1.Text+")", conn);[/CODE] how should i do it if i dont …  |
| | Hello, can you help me convert MS SQL DateTime to miliseconds since 1970? Thanks, Domen |
| | Dear all, I am very new at SQL programming and are using the Microsoft Query to avoid alot of SQL programming, but I am stuck on one thing when I try to filter some data from the database... I want to show all delayed deliveries to our customers... Our Policy … |
| | Hi everyone, I'm currently working on a assignment and have to write a short (max 3 lines) definition on some different kinds of queries. I've written a definition to all of them but I'm having a really hard time about one particular query: Scan Query. I've tried to look in … |
| | Hi everyone, I’m having some difficulties with a query which purpose is to give users with more than one thread (called CS) in current year a 5% point “raise”. My relational schema looks like this: Thread = ([B]threadid[/B], threadname, threadLocation) threadoffering = (threadid, season, year, user) user = ([B]name[/B], points) … |
| | I am developing a website in ASP.net 3.5 where there is a very big database. I have to show data on one single page dynamically changing from the database and that database will contain data of about 4000 pages having text and images. With formatting tags and lot of tags, … |
| | Hello everyone, I'm not sure the title fits my question, but I didn't know how to word it correctly. Here is my question. I'm working on a forum that pulls data from a SQL database via PHP. It's data on employee data (name, job title, what programs they have access … |
| | OK I'm not really sure how to put it but I will try my best to explain my question. Basically I am really lost when it comes to arrays and for loops, so I need help badly. I have in my HTML Form about 20 checkboxes like this: [CODE]echo "<input … |
| | Hi everyone and thank you for helping me... again :icon_neutral: I am trying to perform a MATCH AGAINST sql query on one of my table called "what". [ICODE]id (int 11) PRIMARY org-id (int 11) keyword (varchar 100) FULLTEXT bid (DECIMAL 4,2)[/ICODE] I want to perform a search on the column … |
| | So here is my search query set [CODE]/all possible input combinations //name and id combinations if($q != '') { if($id != '') { $sql = "select * from course_participant where name LIKE '%$q%' and nic='$id'"; $result = mysql_query($sql); $num_rows= mysql_num_rows($result); }else{ $sql = "select * from course_participant where name LIKE … |
| | I have been trying to inset an excel spreadsheet into oracle. I can import everything fine but whenever I need to import dates it does not work. is there a special formatting I need to do with excel? I have tried every step that I can possibly think of. whenever …  |
| | What I'm working on is a video rental project in visual basic 2008. I have a local database which contains info on DVDs, Members and a table for current rentals. [B]The columns i have in the current rentals table are:[/B] MemberID | DVDID | DaysOnRent | DateRented | DueDate | … |
| | I have a database I am creating with about 50 users over a network. There are about 6 groups of users and these users are spread across 10 branches. I want to block/allow users from particular forms and views. For example I want branch users forms to be filtered by … |
The End.