1,694 Topics
 | |
| | I am working on a VS2010 Winform (not ASP web form). I have a copy of the local database on my computer. In this application, I have 3 forms in my application that need to connect to the same database, but different tables. Right now I am defining my connection …  |
| | ok so , i have a sql query puzzles . say that i have a table "PERSON" with the data look sumthing like this: PERSON Name ID ----------------------- John 12123 Kimberly 33311 Leo 87892 And i have a table score that look sumthing like this: SCORE ID MARKS ------------------------ 12123 …  |
| | Hi, I am writing a little app that will have a rich text box that users will be able to write SQL statements and save them to SQL Server table. I would like to validate the SQL statement before saving the string. Because another process picks up the string and …  |
 | $plugins = $Server->Get('plugins'); echo "<br /><br /><b>Plugins</b><br> "; foreach($plugins as $plugin) { echo $plugin."<br>"; } That snippet above spits out a long list of plugins from a server. How can I store each plugin listed into SQL so that its stored as '$plugin[0]<br/>$plugin[1]<br/>$plugin[2]<br/>' and so on so that when I … |
| | I'm learning as I go here, but I'm stuck at the moment. I am trying to dynamically create a datagridview and populate it from a database using SQL. I have created my columns, but I don't know how to assign the data coming out of my sql query to its … |
| | In my program, I have a section to insert information about a customer into an Access database. I get the error below at the .ExecuteNonQuery. Message: System.Data.OleDb.OleDbException (0x80004005): Field 'Customer.Business_Phone' cannot be a zero-length string. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& … |
| | Hi all, Anyone know how to create a data base gives the name of the same parameterized? Example in a store procedure, named 'x', which has a parameter, this will do since the create dabase @variable create procedure creadatabase @db_name varchar (10) as create database @db_name go But this variable …  |
| | I have created a cube in visual studio, when i want to deploy it i get the following error: Error : The project could not be deployed to the 'USER-PC\SQLEXPRESSR2' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service … |
 | Hello i have a database table | col1 | col2 | col3 | col4 | col5 | | val | val | val | val | val | | val | val | val | val | val | | val | val | val | val | val | … |
 | Hello, i got this error when i click my button save. Error: .Net SqlClient Data Provider: Conversion failed when converting datetime from character string. please help me... this is my save button code: Private Sub btnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim check As Integer Dim … |
 | Hello I am using Apache derby embedded database: I have been using a system to display records from the database described in "DisplayInstructorAvailableNowJTable.java". it allows the result set to create a model from a prepared statement. I have only uncovered the tip of the iceberg concerning JTABLE. I am not … |
| | Hi guys, I'm a student and need to practice Oracle SQL queries since we have Advance SQL in our syllabus. I have Intel-based MacBook Pro running Mac OS X Snow Leopard 10.6.8. I just downloaded the SQLDeveloper for Mac and unzipped it. The application executed and started well. But I'm …  |
| | Hey all, This website is a directory and the problem is authenticating users to edit a server, even after they've logged in. The idea is to stop any SQL mix-ups due to my weak code (I'm learning PHP). When they click 'Edit' next to the server after logging in they … |
| | In my page, there are 3 drop down menu. Dropdown 1 : for storing car model which retrieved from CarTab in database (SQL) Dropdown 2 : for storing username Dropdown 3 : for storing plate num The function of the all drop down menu, there are related to each other. …  |
 | when i use sha 512 on password field then it says k pasword field cannot be empty but when i remove sha512 constraint then it works and with any other hash it also works why ? and plz suggest me some good secrity hash etc to apply on password field |
| | Hi there, I have Page that goes to "sub categorys", but each time I upload a new product the subcategory gets duplicated each time, instead of having one "Vintage" category as I want I have duplicates. My current SQL query string is SELECT DISTINCT Picture, SubCategory, Categorie FROM Table1 WHERE …  |
| | Hi, I have a dynamically generated sql query that is generated in VB6 and then passed on to SQL Server 2005. The query joins(inner join, left join, etc.) multiple tables. If I were to execute that query in Sql Server Management Studio, I would get something like this: TrayID| TrayID … |
 | Hello hi. I am seeing flames with using FILESTREAM in SQL Server 2008! I have a table (Products), in which I wanna store a link to an image stored on disk, under the ProdPicture column. This is what the script looks like: CREATE TABLE PRODUCTS ( ProdID INT PRIMARY KEY, … |
| | I'm making a B2B portal that can see just loggedin business customers that I add to base, I finished almost all, but there is one problem. When customer add some goods to his cart, goes to checkout and confirm his order he will have a link to invoice.php?ids=156 and that … |
| | In sql server 2008, i have a store procedure which has insert statement , now i want to insert multiple records at a time into table via EXEC. MY Store Procedure: insert into tblUser(fullname, email, loginID, password, DOB, question, answers,doc,roleid) values (@fullname,@email,@loginID,HASHBYTES('sha512',@password),@dob,@question, @answers, GETDATE(),@roleid ) Now how to insert multiple … |
| | i have this page in hard form and i need to make a table for it in DataBase (Sql Serber 2008), i tried alot but couldn't find any way to make table for it in data base. + i have also user table in DB, so userid should b also … |
| | Hey Everyone, I am using the below query to try and group together values by the month of the date selected. the problem is that sometimes CTE2 will not have the same dates as CTE and those values end up omitted. Is there anyway I can just group these on … |
| | I used the upsize wizard in Access 2010 to split my database with the table being on the SQL server. I entered this in the autoexec (was macro, I converted it) Function autoexec() oConn.Open "Driver={SQL Server};Server=JCPLMSQL01;Database=TestingConnection;Trusted_Connection=yes;" DoCmd.OpenForm "Form1", acNormal, "", "", , acNormal autoexec_Exit: Exit Function End Function I don't …  |
 | Hi there, I've lost my password and username and am trying to log in using sysdba. It doesn't log me in and I would like to retrieve my username and password without re-installing the software. IS there a way of doing that?> |
| | I have read many articles here, but haven't quite found the solution. I have a SQLEXPRESS database that is used by my VB.NET application. I have packaged and deployed the application via an MSI file and everything works great except I cannot figure out how to include my database file … |
| | Hi All, Ever tried to make a change to a SQL database table only to get a message telling you it is unable to carry out the change as it would have to drop and recreate the table? This is one of these things that you encounter once, correct and … |
 | Hi all, I have a .NET form where I want to connect to a table and then pass each defined (by query) string from the table into a string within the code. I have created a connection to the database already via Data Sources but I'm unsure about the syntax … |
| | I have looked into Cast and Convert, but I cannot find a way to do this. I need to convert four digits into an hour format. For instance, 0800 would become 8:00 or 1530 would become 15:30. I cannot use functions, I'm using a special form of SQL. Any suggestions? … |
| | Hey everyone, I am looking to write a query that I think can be solved a nested select but I am not yet that fluent in MySQL to be able to get the query working correctly. Basically what I want to do is this; SELECT count(*) from Inquiry Inner Join … |
| | Hello, I have 3 tables, user, role and userrole. Userrole stores user_id and role_id, so every user is associated with some role(s). So, when i use this query to view all users, and if user has several roles, i can see several rows with identical info and just role column … |
The End.