6,934 Topics
 | |
| | yes. my coding as follows Public Function connectDB() connStr = "Data source =KIRAN;Initial Catalog=eStaffMgm;Integrated Security=SSPI;User Id=**;Password=*******" connSQL = New SqlConnection(connStr) Return connSQL End Function My system name is Kiran and the database name is eStaffMgm The default instance of SQL Server 2012 is MSSQLSERVER The code in the module was …  |
| | My computer name is Kiran and i installed VB 2013 and SQL server 2012. but when i connection to Database is not working. can i have way to connec  |
| | OK so I have already created many pages with my paging all working correctly however I have just created a new paging page that allows the user to use a search criteria. With the paging and search when you click on page 2 it dosen't load and dosen't display any … |
| | Hi, . Could you please provide me a code sample showing how to load a treelistview from database with hardcoded root nodes on treelistview. I have shared the link below of a sample preview of the tree I am in need of. Rootnodes are hardcoded and I want the child …  |
 | Having problem with looging in my server. Before it runs smoothly. While learning this system, I came accross the idea of exploring the contents of Microsoft SQL Server in Program Files. I found some exe files inside and tried to run them with the curiosity of what are those for, … |
| | Hello, I would need some help/hints/tips for installing MSSQL server 2008 on a Windows Server 2003. Details: I want to work with virtual machines. My computer is an old one, not able to virtualize x64 machines. That's why I use Win server 2003 32 bit with MSSQL server 2008 R2. …  |
| | how to can i insert data in another table without using wizard dataset and i have a variable that date and time that can be used on date time picker please help can anyone simplyfy the code?  |
 | Hi , I am working on a list : Name Town Street House ID_Number Marco Valletta Triq l-Ajkla 10, Fl 1 53290M Mary Valletta Triq l-Ajkla 10, Fl 1 4748M Victor Valletta Triq l-Ajkla 10, Fl 4 37867M Krystle Valletta Triq l-Ajkla 14, Fl 1 52467M Mariella Valletta Triq l-Ajkla … |
| | I know how to create view in sql , but I've never used it. I was wondering how creating view can be helpful and how can I use view created on APEX  |
| | I have these tables and I want to show the percantege of customer with deliverd to pending and the in another sql statment show the number of customer with deliverd to pending I'm not sure how to calulate these two. I tried the build query on APEX , but it …  |
| | Ok so I have three tables Customers,Invoices,and Delivery with the fields: Customers: CustomerID Address ........ Orders: OrderID DeliveryID ....... Delivery: DeliveryID DeliveryToAddress ...... So what I want to do is update my delivery table for the DeliveryToAddress for when the customers address changes within the customers tables. To get the … |
| | I have a webiste and would like to send an email to someone, and myself, when they request their lost password. For some reason, I can't get the mail() function to work, no matter what I do. I unsuccessfully tried to model it after the listserv I created and am … |
| | Hi All, I have a problem with my Microsoft SQL Server. When I execute my queries, it did not appear. The screen says, "Save Result as". I already unchecked the "Prevent saving from changes...." from >>Tools>>Options>>Designers>>Tables and Database Designers but it keeps in appearing. Please help! Thanks in advance :) |
| | Hi Just asking for a better solution for my approach in getting sql result with different multiple conditions based on comboboxes. I have a 4 comboboxes, for Branch, Type, Status and other info. User can select conditions from this comboboxes. The default value is "All", meaning no specific condition at … |
| | I am currently working on a project that involves saving a picture to a sql database. I have done quite a bit of research on this and have found a lot of useful stuff but nothing where I can actually develop some code from. Simply put, it is a datagridview … |
| | Hi All, I am trying to add insert/update and delete to an OOP singleton database connection using public functions like this, not sure if it is correct? example code public function insert($sql){ if($this->_execute= $this->_mysqli->_execute($sql)){ while ($row = $this->_execute->fetch_object()){ $this->_results[] = $row; } $this->_count = $this->_execute->num_rows; } return $this; } //page … |
| | Hello everyone, I'm writing up a new application that instead of using microsoft as a server, I'm using a linux server with a database in it. The database was setup, the tables were set up, and access was granted in mysql. The issue I'm having is that I keep getting … |
 | Hi, Am new in VB.Net.I want to know how to call for data from SQL server usin code. Thanks |
 | I want to get the maximum Column5 from both the table and then the maximum Column3 from the table which has max Column5. I don't know if it is the right forum and also am not good in sql :( SELECT max(Column5_1) FROM (SELECT max(Column5) Column5_1 FROM TABLE1 WHERE Column4 …  |
| | Hey guys, So, as the title says, trying to join four tables. The purpose of the script is to: 1. Get the username of members being "followed" from table called following 2. Find the status updates of members in step one from table called status 3. Retrieve all comments on … |
| | Hi! Can anyone know the result of this query: SELECT COALESCE(MAX(ID),0) + 1 FROM Table123 |
 | for($i=1; $i<=($jumlah_row_tabel_atas+1); $i++) { $satuan = $_POST['PP_row_'.$i.'_satuan']; $word_2[$i]="SELECT id_unit FROM manage_unit WHERE name_unit = '$satuan'"; $q[$i] = mysql_query($word_2[$i]); $data_X = mysql_fetch_array($q[$i]); $id_unit = $data_X['id_unit']; $harga_1 = $_POST['PP_row_'.$i.'_harga_1']; $harga_2 = $_POST['PP_row_'.$i.'_harga_2']; $harga_3 = $_POST['PP_row_'.$i.'_harga_3']; $id_drug = $_POST['id_drug']; $value = $value_array[$i]; $word="INSERT INTO relation_mu_and_unit (id_drug, id_unit, priority, value, harga1, harga2, harga3, last_edit) … |
 | What the webpage would do is after clicking "SUBMIT" button, a php script will be use to add records into my database. But for now i do not know where to put the "signupinsert.php" into the html and to make it run. I have try putting it at form action … |
| | hi I am trying to save multiple images into one ID and I am getting no where ...I am posting the code so for storing and retrieving image (one image)...but need to store more than one ....need some help here ... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using … |
 | I'm developing an application in which i want the software to be executed at any place. So i want the database to be placed in one computer. This is the scenario. All the computers will be networked. Can i do this in c#.net ? Please tell me the procedures. Thank … |
| | Hi, Im having a hard time figuring this maybe a simple query. This is my first time to use sql compact edition. How can I query a select statement inside a select statement which tables are not related at all. What i need to accomplish is to insert a logo …  |
| | i have a problem in choosing data type for this column in SQL..can anybody help me??? result (tournament_id*, player_id*, round) i've done the first 2 columns, i'm confused about the data type of round=='...i wondered if it was cstring or text or numeric here's my code : tournament_id int, player_id … |
| | Hi Everyone, Thank you for the time you spend to look at the post. I am required to retrieve report based on a date field in the table. the date field filtering must be from the previous month of the 6th till this month of the 5th. For example, today … |
| | I'm working on a insert form for my movie database and I have some code working and will be adding more to it, but I wanted to know if there was a better way to go about doing some of this or if I have made a huge coding error. … |
| | I have a database with a table, jobs and i have written this query to get information from this table. But i am getting no results with this data and i have no idea why? SELECT startDateTime, endDateTime FROM jobs WHERE startDateTime BETWEEN '19/11/2013' AND '20/11/2013' Database Structure: 1 jobId … |
 | how to connect sql server 2000 database with multiple connections I got a sample database DB1 and DB2, the DB1 I have table A, and I got a table on DB2 B, between A and B table no direct relation thanks for the enlightenment |
 | |
| | I have created a table in mysql database table(tblmysq) with id(autoincrement),name(string),branch(string),sex(string),and dat(datetime).The following error occurs when i try to insert a record:check the manual that corresponds to your mysql server version for the right syntax near line 1. My lines of code are : Try conn = New MySqlConnection(conStr) conn.Open() … |
| | Hi all, I am trying output the following 1 user after validating data from a database and I have no output to the screen. I am not sure what is missing from query? Any help would be appreciated Thanks in advance David ------- Index.php ------ <?php session_start(); ob_start(); include_once ("includes/settings.php"); … |
 | Hi All, I want to get all the IPs of the A RECORDS for **mail.google.com**. The aim is to deny access to these IPs. I learnt that mail.google.com has several IPs. I did the following steps: 1. whois google.com 2. I got the following as its DOMAIN SERVERS: ns3.google.com ns2.google.com …  |
| | Ok, before I start, DANIWEB is my last resort to get help. it seems the people on the other sites are having trouble understanding and/or helping me with this... anyway, here is what I am trying to do: I have a website with a folder structure that I allow users … |
| | Hi, is it possible to combine Stored Procedure and Text Command Type in Select Statement? I have a stored procedure that compute available items, it quite a bit long select statement, now i need to call this statement in another select statement which is in text command type, how will … |
| | Hello friens I have SQL server 2003 and I need books or online materials regarding SQL query ( All type of SQL query ) like examples and methods to run such queries. Would you help me to find the reliable materials ? From where in INDIA I purchase best book … |
 | i almost spent 3 hours on EXISTS operation, used in SQL especially with subqueries, i got its purpose :) that's ok but what i don't get is that WHY TO USE IT ? e.g. couldn't understand this example: *TABLE STORES* storeName----Sales-------Txn_date *TABLE GEOGRAPHY* regionName----storeName SELECT SUM(Sales) FROM Store_Information WHERE EXISTS … |
| | ALTER FUNCTION [dbo].[customers_udfMin2] ( @decission tinyint ) RETURNS int AS BEGIN -- Declare the return variable here DECLARE @min int Declare @default int = 10 -- Add the T-SQL statements to compute the return value here if (@decission = 1) Begin SELECT @min = MIN(customers.cus_id) from customers End else RETURN … |
| | I need to get the name of the table with the biggest number of rows, I can find the biggest number of rows with function count and than function max, but i don't know how to see from which table is that maximum, can anyone help? tnx |
 | I'm starting my Computing project and am using Python linked via sqlite3 to a database. As part of my project I shall be searching for maths books in the database via name or module etc. I wish to display the results on a GUI in python so need to set …  |
 | 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 'NOT NULL, CreatedOn DATETIME NOT NULL, ModifiedOn DATETIME NOT NULL, `StartD' at line 1 CREATE TABLE `billing`.`ebUsers` ( `UserID` INT NOT NULL AUTO_INCREMENT … |
| | I'm working on making a user maintenance system for my class, I have created the add/delete user portion but as for the edit portion I am completely stumped. So far I have created the form but what I want to do is be able to hit find user and then … |
 | Hi Everyone, I am needing some help with a wordpress insert query. I have this update query $qry ="UPDATE `".$wpdb->prefix."comments_real` SET `comment_country` = '$country',`comment_number` = '$phone',`comment_smvcode` = '$ref' WHERE `wp_comments`.`comment_ID` =$comment_id"; how do I change this to insert a new record in a db table called "comments_real" Thanks in advance |
 | Hi all, Im working on a page that sends information to a mssql database. Its a basic registration page with a UserID, Password, First Name, Middle Name, Last Name, and Email box. When Sign up is clicked, all the information in the textboxes should be sent to the Users table … |
| | Hello. I'm trying to use SqlDataReader to return information from my database. It works fine until it comes to a datetime field. I'm getting an error saying: " Input string was not in a correct format." on the line where I'm declaring a variable to hold my field. Here is … |
| | Good Morning All, I need some help and guidance on a project I'm working on, I am having problems with the following code below, I have been trying to figure it out for days and cannot see anything wrong with it, I am getting the following error when processing the … |
| | Hello. I have an old access data project. I need to convert it to sql and .net. How can I do that? |
| | How do I connect from another machine to SQL Server 2008 R2 Express installed on Windows Server 2008? I've setup the network configuration to be enabled and the TCP port is set to 1433, but I still can not connect to an existing database on the server when creating ODBC … |
The End.