6,934 Topics
 | |
| | This is my vB.NET assignment and i have no idea what it requires. I have not done this practical before b'cause the lecturer has not taught us about the joining the SQL in VB.NET and I'm seriously dont know how to do this......so i need help and pls do help …  |
| | I am trying to create a sql statement like set @sql = 'select @stage1 = count(MY_ID) From VW_OPEN where ' + @filter and run it with exec (@sql) However this generates an error Must declare the variable '@stage1'. If I run statement select @stage1 = count(MY_ID) From VW_OPEN the var … |
| | I need to write a query that will pull my products and price. However each of the products have multiple prices and I want the price with the most recent date. I have tried the following query but it doesn't work. Can someone assist me. I'm fairly new to sql … |
| | Dear Friend I am trying to perform the flowing tasks using the following SQL statement in Microsoft Access but they don’t work. I wonder if someone could help and tell me what is wrong with my Statements. Whenever I run these statements it will not create the query. [B]Task 1: … |
| | Hi there! I'm building a small application using Java and MySQL (college assignment). Everything is ok when all I'm doing are queries using SELECT. Now, when I try to INSERT anything in the table, I get this error message: java.sql.SQLException: Can not issue data manipulation statements with executeQuery(). 0 S1009 … |
| | I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance, |
| | Hey. I would like to ask for help regarding SQL server. I have developed a client-side application to run on my clients' agents machines. They will use this software to add items to a cart and print an invoice, in addition to the program eMailing my client to notify him …  |
| | [B]Scenario:[/B] I have 2 gridviews, clientgridview for showing the clients and the projectgridview for showing the projects. If I Click on the Client name on the the clientgridview i will be directed to the project gridview to show the different projects of the client [B]Problem:[/B] when i click on the … |
| | can u spot the error in this code.. [CODE] Private Sub fncExcelExport(ByVal strSql As String) 'fncExcelExport("SELECT * FROM tbl_rop WHERE Name_User ='" & (TextBox1.Text) & "', Date_of_birth= '" & (TextBox2.Text) & "' , Hobbies='" & (TextBox3.Text) & "' , Phone_Number ='" & (TextBox4.Text) & "' where Name_User = '" & … |
| | In reading and posting on this forum, I see a lot of code here that doesn't consider sql injection. SQL injection is an attack where the attacker terminates or modifies an sql query with input data. Here are some samples: [url]http://en.wikipedia.org/wiki/SQL_injection[/url] [url]http://www.unixwiz.net/techtips/sql-injection.html[/url] [url]http://www.securiteam.com/securityreviews/5DP0N1P76E.html[/url] In Michael Howard's blog, he wrote up … |
| | [code=ASP]<html> <title>CodeAve.com(Create Excel on Server)</title> <body bgcolor="#FFFFFF"> <% accessdb="a" cn="DRIVER=Microsoft Access Driver (*.mdb)};" cn=cn & "DBQ=" & server.mappath(accessdb) Set rs = Server.CreateObject("ADODB.Recordset") sql = "select id,empname,phone from empp" rs.Open sql,cn rs.MoveFirst file_being_created= "states.xls" set fso = createobject("scripting.filesystemobject") Set act = fso.CreateTextFile(server.mappath(file_being_created), true) act.WriteLine("<html><body>") act.WriteLine("<table border=""1"">") act.WriteLine("<tr>") act.WriteLine("<th nowrap>id</th>") act.WriteLine("<th nowrap>empname</th>") … |
| | i have installed oracle 9i sql but while installing forms & reports it gives errors to run sql/plsql. pls explaine me the right steps to install oracl 9i & forms n reports. so pls help me that i can run both sql & forms reports. |
| | We recently had a MSSQL injection on our server and don't know why it happened. We get a funny email in our ticket center that is at another data center that says we have an exploit in our code and then two hours later the server get hacked through our … |
| | Hi. Can anyone tell me how to create a mobile database and application using SQL Server Management Studio Express? |
| | <URL SNIPPED> This site contains 2000+ ebooks on php, Java, access, .NET, c#, UML, Perl, c++, linux, sql server, asp.net, Oracle, db2, xml, javascript, unix, flash, cisco, excel ... |
| | I am also getting a disable icon in the bottom right coner of my systray next to the clock. It flashes and popsup a box saying somthing about a virus alert get a animalware scanner program. I click on it I go to spyfalcon. Used it nothing happened. I did … |
| | I'm getting this error message [B]An exception occured while executing a Transact-SQL statement or batch (Microsoft.SqlServer.Express.ConnectionInfo) CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error:262)[/B] When I try to create a new database from the right click option on the master DB. I think this is a permission … |
| | Hi , i am trying to retrieve a row of data from a SQL table,but i dont get the results,i just get the variable($stock_code) that i use to search for the row on the screen. <?php include "dbaccess.php"; $stock_code=$_POST["txtStock"]; // Insert the required SQL query here. $query = "SELECT STOCK_CODE …  |
| | I keep getting an error where the symbol cannot be resolved and the arrow pointing to where i have written statement.ExcecuteUpdate Am not able to insert any data into my database, can anyone see where i may have gone wrong. thanx heres the code: <%@ page import="java.sql.*" %> <%@ page … |
| | Hi, I am a newbie to PHP and HTML and over here i am trying to display my sql results in a table format like this, ID. Name. Contact --------------------------------------------- ----ROW1---------------------------------- ----ROW2---------------------------------- any site recommendations where i can get help from? thanks alot. |
| | Hello i am final year engineering student and i am doing my project to control appliance via personal computer.For every appeliance and home ,i created sql database and an application program in vb.net so that the user can switch on or off the applicance as he/she pleases. now the problem … |
| | I have recently started free domain name service <snip>. I used turnkey redirection script. My script uses php with SQL 4 . My hosting Uses sql 5. I face problem while installing. Can anybody give a solution |
| | Can anyone please post the tutorial for connect SQL server over the WAN. I have been using my SQL server in the LAN without problem. I am not able to connect with the STATIC ip and this is connection string for LOCAL. conString="PROVIDER=SQLOLEDB;SERVER=192.168.1.1;UID=XXX;PWD=XXX;DATABASE=TEST" I have tried with coneectionstrings.com and helpless. …  |
| | i have a mock site im working on in asp.net/vb.net using an access database. after employees log in they can update there employee profile by filling out a form. i need to know the code for updating an access DB with vb.net from the form fields. im lookin for the …  |
 | Hi, What I have: 1) Table in SQL Server 2005 2) Table contains column of xml datatype 3) The column has Xml Schema defined I need to do three things (in C#): 4) Get the Xml Schema of the collumn 5) Create dataset based on that xml schema 6) Load … |
| | |
| | i want to insert values selected from multiple selected listbox in to a single column seperated by a delimiter(,) along with this values there are some other rows too in which some other values are inserted a table has prdt_id, empiid 1,3,4,5 45,23 values shld be in this way how …  |
| | I am joining two tables with INNER JOIN and I am getting duplicate entries. I used DISTINCT but its not working. Do we have some other keywords for the same? Thanks in advance, |
| | Thank u so much for sending this code,and i appreciate it so much.But i need to be able to move foward by getting thesame code that will save into the database,Others conversion i used were'nt working.Pls help me with the code that will save in to the database(SQL server) with …  |
| | i am developing a project so it involves working with picture.i have a code in vb6 that can retrieve image from the sql server,the code is this.And i need exact of such code that will be able to save into the DB,to avoid disparity in the binary conversion. Dim CN … |
| | Good day to all. I have an existing vb project and my back end is ms access. I changed my database to MySQL and SQL but the problem is I don't have any idea how to connect my VB project to MySQL and SQL throuch ODBC. Your help is very … |
| | Hi guys, I have this sql statement that is trying to insert data from some fields <?php $con = mysql_connect("xxx","xx","xx"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("xxx", $con); $sql="INSERT INTO guests (guest_name, guest_email) VALUES"; for($i=0;$i<sizeof($_POST);$i++){ $sql.="('".mysql_real_escape_string($_POST[$i])."','".mysql_real_escape_string($_POST[$i])."')"; if(!$i==sizeof($_POST)){ $sql.=","; } } // if (!mysql_query($sql,$con)) { die('Error: ' …  |
| | I've posted something along these lines before, but it's a tad bit different this time, hopefully some of you can point me in the right direction. I'm designing a tool that will make adding things to a database easy for people not familiar with SQL, it will basically export a … |
| | I have a table which have person's name as Prefix, firstname, lastname, address as three different columns. I want to get all records when fire a query like SELECT * from Persons where name= 'abcd' I want such query which can search in all three columns, it means abcd can … |
| | Hi all, I m converting stored proc from sql server to oracle. first have a look sql stored proc. create procedure xyz.. as begin -- i have created one temp table -- then inserted some data into it by select query over some db table. -- then i have another … |
| | eloo... i got the code to get data from sql to excell...but only the data that are displayed in textbox created early..i want to know how to grab all data and stored in excell...i created a table in sql nme tbl_rop and the attributes are Name_User, Date_of_birth, Hobbies, Phone_Number... this … |
| | I'm new to JSP and trying to do a parameterized query. I've been able to do single stream queries to existing tables without any problem. I'm trying to build a search mechanism to do selective reporting. I've tried many hours to get the combination of different items to get by … |
| | Hi all, I hope someone can assist me with this. I have two databases and i need to replicate (on a regular basis) a couple of tables in one into the other. Any suggestions of the best method of doing this? with thanks Scott |
| | hi all, I have two problems 1. When i am updating the value of table manually. i am facing the error : The data in the row1 was not commited. Error Source : .Net SQL Client Data Provider Error Message : Time Out Expired and Second one is also related … |
| | I want to make a procedure that runs at every day at certain time. I read that I have to do Scheduling, but to do it I should have sql server agent. I am using sql server express edition with sql management studio express endition. But there is no sql …  |
| | Hi all... great forum! I'm basically on a crash self-learning course in Coldfusion and database-driven sites, so I'm pretty sure I'm missing some basic concept that would make this an easy query. If anyone could point me in the right direction I'd really appreciate it. This is for a site …  |
| | Ok, I have a e-commerce store that uses stored procedures to sort products. I have figured out how to sort my name and price but am having trouble sorting by rating bc the rating table doesnt have all the productids (only ones that have a rating) and also the rating … |
| | I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the small text field (stringText [char]) only has a length of … |
| | I've built a small PC app that resides in the Task Bar Tray until one of our employees sends a signal to it with a handheld device. When the PC app is activated, we connect to the SQL Server to retrieve records using Integrated Security on the PC:[code=vb]Private m_conn As … |
| | Just started SQL Class and I am struggling with an assignment. Would someone be kind to give me some help please? your task is to make a stored procedure that will only billcustomers making monthly payments higher than $500.A Customer can have multiple Plans (services for which they pay amonthly … |
| | Hi All, I am new to .Net. can anyone please tell me how to create loginpage in detail with steps and code. Thanks, Swapna |
| | Hi guys, I was wondering if someone could help me please. How do i query the database using ASP and Dreamweaver to return the field names of a table? Thanks! Any ideas greatly appreciated. GLT |
| | I am having a problem porting an application written in ASP, using an MS SQL Server database, to a different ISP using MySQL. Code that seems to run fine on the current site generates errors on the new site. My connection to the MySQL db is: [code] set objConn = … |
| | Hi I would like to know what does constitute a Sql Developer, I want to do the transicion from Data Analyst to Sql Developer; however the descriptions I see online dial with performance and tunning or DW housing. Can some one explain? I have 5 year on the field Sql … |
 | Dear all, I filter my query select with parameter from previous page. SQL = "select a.KodePenyanyi, p.NamaPenyanyi, p.WebSite, a.KodeAlbum, a.NamaAlbum, NamaLabel, Tahun, a.Kaset, a.CD, a.CDImport, a.DVD, DaftarLagu, ReviewAlbum FROM masterpenyanyi p inner join masteralbum a on a.KodePenyanyi=p.KodePenyanyi inner join masterlabel on masterlabel.KodeLabel = a.KodeLabel where a.KodeAlbum='" + kodeAlbum + "'"; …  |
The End.