6,934 Topics
 | |
 | Trying to update Packet.MSGState to P where if not R or D and it is Y in table Packet.MSGState SQL is MS-Access var ODBC from c# This is not undating all correct. UPDATE Packet SET Packet.MSGState = 'P' Where (MSGState <> 'R' and MSGState <> 'D') and Exists (Select MSGTO.Selected … |
 | dashboard2.php if (isset($_POST['ok'])){ if (empty($_GET['class_id'])) { $class = $_SESSION['class']; $sqlstr = "INSERT INTO material2(`subject`, `title`, `content`) VALUES('".$class."', '".$title."','".$content."')"; echo $sqlstr; } else { $class = $_SESSION['class']; //echo $class; $sqlstr = "UPDATE material2 SET subject='".$class."', title='".$title."', content='".$content."' WHERE class_id=".$_GET['class_id']; echo $sqlstr; } $result = mysql_query($sqlstr) or die(mysql_error()); //Jika mode edit, maka …  |
| | i hv 3 different user,user selection is based on radiobuttonlist and then login button,but im having error that "use of unassigned local variable 'sql'.I couldnt figure out the mistake.do help me :) protected void btn_Login_Click(object sender, EventArgs e) { string sql; if (btn_user.SelectedItem.Text == "Admin") { sql = "Select * …  |
 | Hi guys, I hope this is the right section to post. I need to develop an application in visual studio 2012 that uses SQL (please bear with me as I'm not very well versed in databases and SQL and therefore I don't know what SQL visual studio uses), and when … |
| | please assist. i can not connect to my sql server (172.16.15.119). i always get this message"Fatal error: Call to undefined function sqlsrv_connect() in C:\Program Files (x86)\EasyPHP-12.1\www\malunde\connect.php on line 5" and the code that i used is: <?php $serverName = "172.16.15.119"; //serverName\instanceName $connectionInfo = array( "Database"=>"TPA-CS_UAT", "UID"=>"sa", "PWD"=>"tpa123"); $conn = sqlsrv_connect( …  |
| | |
 | Hey all, so i am working on database queries. Add and delete are working fine. I am having trouble with Edit Query. This is what i am getting: Incorrect syntax near 'Name'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace … |
| | Good day, gurus of this well-known site. I am using vb.net 2013 Ultimate and SQL 2012 and can someone show/link me how to save and retrieve a word document from SQL database? Thanks  |
 | Hello, I need a little help with trigger, I have been doing database development for a long time now but this is my first go around at a trigger. It is not working, can someone please look at this and let me know what I am doing wrong: ALTER TRIGGER …  |
 | So hopefully the title makes a little sense, but I'll explain a little more. Currently I am developing a program at work that is designed to query a SQL database for results. The code is meant to be stand alone, a single .exe that can be run on any machine. … |
| | There are a lot of examples demonstrating how to connect to ms sql database from windows form application using Visual Studio Professional (right-clicking on the project name -> "Add" ->"new item" -> "LocalDatabase" -> give a name with .sdf extension to the newly created database - > and so on …  |
| | I am trying to do a check to see if a student meets the prerequisite before they can register for a course section. CourseSecID = 27 (ID of the course section the student wants to register for.) What I am doing is querying the student's acad cred records to see … |
| | I have problem to copy data from one table to another table in SQL database. I am develop the system using C#.Net. I have searching about it from internet, but it not works. I have two table: 1) Project_Pipeline (company_name, project_name, project_revenue, gross_profit, category_pipeline, status_pipeline, bde_name, deadline, remark, pipeline_id) 2)Proposal_listing … |
| | I am trying to make a graph from data that i have in my sql database. Below is the exmaple of the data that i am pulling from my data base. Region LC_count MC_count NC_count B_count LL_count EL_count LR_count CR_count MOUNTAIN 0 722 542 0 7155 0 0 1444 NO.CAL/NEVADA … |
 | Hello all, zoidmaster here. I have a question regarding work with a MS Access database. I have the code written out from a tutorial I found online for a basic database, however all it can do with the database is read, add and delete lines from it. I'm trying to … |
| | I really would like to know the best way of going about this issue I need to union 2 select statements and then do a select statement from result of the union |
| | Dear experts I am running one mysql query which contains selection from multiple tables.The problem is sometimes the query runs very slow, but sometimes it is ok.Acctually when i run it first time it is very very slow, and from the next time it becomes fast.I wonder if it is … |
| | Hi I want to create a plain c++ program which need to connect to SQL server through odbc and retrieve values and display it. I am using qt but i need it in plain C++ . can u anybody suggest the way to achieve it . and any free api … |
 | Hi, Im trying to extract data from sql server where conditions are multiple and variying I have a datagridview with 2 columns ID and Name I need to create Select Query to extract data where condition is 'ID should be equal to the value or values in Datagridview ID Column. … |
| | |
 | I want to disallow certain query strings with robots.txt and I want to check I am doing this correctly... I am using: Disallow: /browse.asp?cat=*-* I want to check that this rule will allow these urls to be indexed: *browse.asp?cat=123/1234/1234-1 browse.asp?cat=123/1234-1* While disallowing these urls: *browse.asp?cat=1234-1 browse.asp?cat=1234-2* Will this rule work? … |
| | Hi! I would like to send SMS messages from Sharepoint when a server goes down. I have found this website that explains how to integrate it with this Ozeki NG SMS gateway. The software is ok when trying to connect the JDBC with my database, and this whole configuration looks …  |
 | I need to know how the primary index is classified as a sparse index? The sparse index as described by some aticles and books has index entries for only some of the search values and has a fewer entries than the number of records in the file. When you make … |
| | I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not be duplicate please review query below. alter proc spUserdetailss @name Nvarchar(50), @passwords Nvarchar(100), @emailadd Nvarchar(50), @Gender nvarchar(50) as begin declare … |
 | I need to make my website responsive with iPhone 5s in media query. I try every thing but can't able to solve the solution for iPhone 5s in media query. Plz check the URL http://foodhub.pk/ Any one can please help me. |
 | Im new to PHP, i just want to know if theres any rule in php in terms of single statement multiple lines. for example in VB.Net we uses "&_"(w/o the quote) to tell vb.net that it is a single statment and it has a continuation. is there any in php? …  |
| | This function I have created to return all recorded Stock numbers in the Table "ContributorDeeds" the table contains only the start number of the stocks and the end number of the stocks (e.g, from number - to number) I need to get all the numbers between within that range. The …  |
| | hello friends I have two tables with column A and column B. I want to update column B of table2 with column B of table1 . I have trying this query in ms access from Vb.net. update table1 t1 LEFT JOIN table2 t2 on t1.a = t2.a SET t2.b = …  |
| | Long story short, I inherited an ASP project. I recently was subject to an SQL injection attack. I'm trying to update the search field that allowed the sql attack. I'm no ASP guru at all and would really appreciate any help anyone can give me on how to check the … |
| | I have a multicolumn listview. There are three button Add, delete and Updata. List is working fine, it add, delete and update list data. But i want to save every row inside listview when i click save button. Bellow is my XAML. <TextBox Canvas.Left="12" Canvas.Top="12" Height="23" Name="textBox1" Width="120" TextChanged="textBox1_TextChanged" KeyDown="textBox1_KeyDown" … |
 |  Hello again, I am now encountering the above problem. i dunno what to do and tried everything. my Column for Capital is decimal so i dunno why it is saying varchar. my codes are con.ConnectionString = //insert data source; if (con.State != ConnectionState.Closed) { con.Close(); } cmd.Connection = … |
| | how to connect sql server with asp.net using vb coding? |
| | What is meant by the bold part of the below paragraph An index is a copy of select columns of data from a table that **can be searched very efficiently that also includes a low-level disk block address** or direct link to the complete row of data it was copied … |
 | Can anyone tell me how can i create a backup and restore form... in vb6.0 for my sql 2014 database  |
 | You may be wondering what a superfecta actually is, and the answer is: the most dangerous and serious threat to business. To clarify, the superfecta as defined by secure cloud hosting outfit FireHost is a group of four attack vectors that comprises of Cross-Site Request Forgery (CSRF), Cross-Site Scripting (XSS), … |
| | I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change … |
| | I worked for 20 years in hardware and twenty odd now in software, so change is an old friend. I consult on UNIX/LINUX to a variety of industries, write lots of bits for my own needs, love to help others over their hurdles. |
| | I'm using InstallShield 2010 and I set the SQL Server 2008 Express as a prerequisite. However, I have an instance of SQL Server 2008 developer edition installed on my pc, the SQL Server 2008 Express prerequisite windows always appear. How to cancel such window if there is any instance of … |
| | Can someone help me explain the coding? if(isset($_SESSION['patron_ID'])) { set_time_limit(0); include 'dbconnect.php'; $studylevel1 = $_POST['studylevel']; if(isset($_POST['submit'])) { do { $senderid = $_SESSION['patron_ID']; $studylevel1 = $_POST['studylevel'];}}} |
| | hi. i'm seeking help with checkboxes.i have built a ordering system. i have two tables "food" and "refreshments" both consists of columns "name,price" . what i want to do is . if i click on my submit button , all the checked checkboxes should be added up and have a … |
| | Hey good people, I hope you are all well. Ok so here is the scenario, i have 4 tables that i have made in sql server 2008. I am using a drop down menu to diplay their names. Like this...  I am going to use a dataGrid view. … |
 | Hi guys, I'm currently on the pretty cool Database development path. I've quickly got to terms with basic SQL with individual tables, and various queries. Now things seen to be getting a little beyond a concept I had been taught from a young age. Am I doing this right. The … |
 | Ok, what I'm trying to do is have next and prev buttons to navigate through a mysql database sorted by date. Currently, the code I wrote does this, but gets stuck on duplicate dates. $Next = mysql_query("SELECT * FROM $logbook WHERE Date>='$Date' AND ID!='$ID' ORDER BY Date LIMIT 1"); $Prev … |
| | dear friends, i allready written code for PHP registration and login forms . i am worried about attacks from user unwanted data entry.My code is below. <?php include"conn.php"; if(isset($_POST['login'])){ $uname= $_POST['username']; $pword= $_POST['password']; $uname =real_escape_string($uname); $pword= real_escape_string($pword); $sql="SELECT * FROM login1 WHERE L1='$uname' AND L2='$pword'"; $result=$conn->query($sql); if($result->num_rows>0){ echo("welcome"); } else … |
| | I have the code if (!(row.IsNull("bigInt") || row["bigInt"].Equals(String.Empty))) { this.bigInt = Convert.ToInt64(row["bigInt"]); } But, it's give to me the error: Cannot inplicity convert type 'long' to 'int'. An explicit conversion exists (are you missing a cast?)  |
| | I have the code if (!(row.IsNull("bigInt") || row["bigInt"].Equals(String.Empty))) { this.bigInt = Convert.ToInt64(row["bigInt"]); } But, it's give to me the error: Cannot inplicity convert type 'long' to 'int'. An explicit conversion exists (are you missing a cast?)  |
 | <item> <HaberKodu </HaberKodu> <Kategori</Kategori> <Sehir</Sehir> <title</title> <description></description> <pubDate></pubDate> <images> <image> 1 </image> <image> >2 </image> <image> 3 </image> <image> 4 </image> <image> 5 </image> <image> 6 </image> </images> <small_images> <small_image>1 </small_image> <small_image> 2 </small_image> <small_image> 2 </small_image> </small_images> <Aciklamalar> <Aciklamala>1 </Aciklamala> <Aciklamala> 2 </Aciklamala> <Aciklamala> 3 </Aciklamala> </Aciklamalar> <link> </link> … |
| | Hi, I was just playing around with using a linq query on a dataTable that has information from sql. I was using var q = from Email in dtEmail.AsEnumerable() where Email.Field<string>("Email") == "yay" select Email; But for some reason it will not query the email datatable. And yes, I actually … |
| | Here is a simple way to insert into a database that isn't much harder than using string concatenation - which we all know is very dangerous due to SQL injection attacks. Put the code snippet into `database.php`. Now, in a script handling a form post, such as `post_reply.php`: <?php require_once("database.php"); … |
| | Please Help me with my problems as follows below : 1 What is the connection string to connect database to vb.net 2 How do i INSERT UPDATE DELETE AND SEARCH records using sql.. 3 How do i start creating a database application using vb.net and sql Thats all... hope you … |
The End.