9,022 Topics
[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>") …
Hi, Im trying to work out a way for users to be able to add new columns to tables in an SQL Server database through Dreamweaver. I have tried using stored procedures but i keep getting errors. The user will choose which table they wish to add a column then …
this the the code for inserting data in a database [CODE]Dim cn As New Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("database.mdb")) cn.Open() Dim cmdr As New Data.OleDb.OleDbCommand cmdr.CommandText = "SELECT [Customer_ID] FROM [Customers] WHERE FirstName LIKE '" & User.Identity.Name & "'" Dim id As Integer cmdr.Connection = cn id = System.Convert.ToInt32(cmdr.ExecuteScalar()) Dim …
I use MS Sql Manager 2008. I need to extract some diagrams from my database. I tried to use reverse engineering in Visio but there is some problem with compatibility Visio drivers with my DB. Have any idea how to set up this and get the diagram(s)? Anyway I found …
hi ... Need help i need code for backup a database.. i want to place the code in a button...
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 …
Cool that worked, maybe you could help me with the overall problem also. I am trying to insert a picture into my database. Now that I have the invalid column name solved I have another error. The error is stating that I cannot insert a null into the column and …
Hi. Can anyone tell me how to create a mobile database and application using SQL Server Management Studio Express?
Hi. Now to start with I'm not asking you to provide me with a solid answer to this, but enough information so that I know where to start looking would be good. I have a project that I am working on which is an Olympic Database. I have several tables …
Hey All! I'm currently creating a database for a payroll system. I have a table consisting of Occupation_ID (primary key), occupation_description, normal_rate and then 3 different overtime rates. I've created a query to calculate the overtime rates for the different overtime rates, i.e. [code]UPDATE Occupation_Rates_Table SET occupation_rate_overtime_1 = Occupation_Rate_normal*1; [/code] …
hey guys, i dont suppose you know how i can go from: id.............result ---------------------- 1..............Pass 1..............Pass 1..............Fail 1..............Pass 1..............Fail 2..............Pass 2..............Pass 2..............Fail to this table: id...........pass......fail 1............3.........2 2............2.........1 my current query is simply select id, result from results I just want to display the total number of occurrences of a …
Hey all I have another problem with my payroll database. firstly, i've created a form for creating/editing/deleting an employee record, which has relationships in other tables (i.e. a table of hours each employee worked containing the employee number, occupation id and hours worked, etc). When i create a new employee, …
I continue to get this message though there are no duplicate keys in the table/s I am transferring into the new table I am creating using DTS. I created a query to look to duplicate primary keys and did not get any duplicates after running it. The DTS is a …
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 …
After creating the table i tried to specify the unique key constraint in sql server 2005 but its asking for the expression. I don't know what to give in that expression. can u please help me out in this. thanx in advance.
Hi pple I've using visual studio 2005 and sql server 2005. I've stored my usernames and passwords in the database. Now i have problems on how to use select statements to check username. Meaning. if username is not found, it gives error msg, if username exist, it compares with the …
Hey guys, I'm working with a database at the minute (not my own), and the two tables are as follows: ---------------------- Customer ---------------------- CustomerID Agent 1 55a 2 97t 3 87f 4 44g 5 63l 6 21s ---------------------- ----------------------------------- Details ----------------------------------- ID DetailName DetailValue 1 FirstName John 1 LastName Smith …
[B]I need code for login verification form, which gets the username and password from the user and verify it in database(sql server) ,if its correct means connect to next form. [/B] help me plsss durai
if i use the query [CODE]SELECT iditem, CONVERT(char(20), dt, 105) FROM planeamento[/CODE] it works just fine.. but in this case the dt (date) field is not recognised.. [CODE]SELECT planeamento.iditem, idmodelo, item_planeamento.idproduto, item_planeamento.idpele, cor, ordemfabrico, qtd, CONVERT(char(20), dt, 105) FROM produto INNER JOIN item_planeamento ON produto.idproduto = item_planeamento.idproduto INNER JOIN planeamento …
Hi I created an DB, that export data to Excel and create a chart from this data, now I want to know, what can I do to filter data and set a criteria eg. A$2:D$46-range, Criteria =2. The filter is not working if I set that critria, for the data …
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 am new to VB. we are using 6.0. we have just switched from Access 2000 to SQL 2000. I was looking for help on the web, and found this site, and signed up. Thanks for the welcome.
I have an datagridview control in c# and i want to update the values in datagridview and need to update in sqlserver automatically.
Hi everyone, Ima working on a business site similar to alibaba.com.In that we have a main categories named agriculture,chemicals ....so on. on clicking on agriculture we get one more subcategory containing different names line plant products,beans so on.. on clicking on beans we get the companies selling beans. similar to …
I have the problem of splitting the the table into following way. Pl help me in doing it Actual table Product Id ProductQty CompCapacity 1 8000 5000 2 10000 5000 4000 4000 Resultant table Product Id ProductQty CompCapacity 2 5000 5000 2 5000 5000 1 4000 4000 1 4000 4000
i want to refresh database(sql server 2005) instantly using c# if anyone does know about the code to solve it please reply me
Hi i`m Andi from Indonesia, very nice to join in this forum. I`m interested in computer programming especially in delphi and sql server which i`m using right now. And i want to learn more about them. Hopefully this forum can be helpful. Thanks.
Hi All, SELECT * FROM Results WHERE ActualValue NOT BETWEEN Lowerimit AND UpperLimit In my query ActualValue is VARCHAR field. How can I get Results that are out of limit? Shrinivas
Hi, here is the results of highjackthis on my system. I seems to be runing real slow and I am having a difficult time speeding it up. Could someone pls look at this report and give some feedback. Thanks, Gordy Logfile of HijackThis v1.99.1 Scan saved at 1:18:38 PM, on …
i create a code to delete a data in sql server..but nothing works anyone outhere help me spot the problem.. ] [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim varAdapter As SqlDataAdapter MsgBox("are you sure want to delete?, important information will be erase. ") 'varConnection …
Hi, here is the results of highjackthis on my system. I seems to be runing real slow and I am having a difficult time speeding it up. Could someone pls look at this report and give some feedback. Thanks, Gordy Logfile of HijackThis v1.99.1 Scan saved at 1:18:38 PM, on …
I did following - [code=sql]create table test_insert_date (field1 datetime not null) grant all on test_insert_date to public create proc usp_test_ins_dt @field1 datetime null as select @field1 insert into test_insert_date values (getdate()) return [/code] After this, I executed the proc as - [icode]usp_test_ins_dt getdate()[/icode] I got error as [B]"Incorrect syntax near …
Hi Guys, I'm new here and have come across a perplexing problem. I have a user table [code=sql]CREATE TABLE Users ( UserID VARCHAR(64), UserName VARCHAR(50) ) INSERT INTO Users (UserName) VALUES ('Tom') INSERT INTO Users (UserName) VALUES ('Dick') INSERT INTO Users (UserName) VALUES ('Harry')[/code] Each user has roles and groups. …
I have SQL 2005 installed on a 64bit windows 2003 advanced server system. I just recently changed the password of the administrator account (which has always had access to sql) and now I can't login to sql. Well, I can. It allows me to view everything, but when I right …
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,
hi developers, i am developing a s/w that need a search. i current using "like" for search. for ex. [code] select * from Tabl1 where col1 like "% Software Developer %" And Col2 Like "% Software Developer %" [/code] But this is not right way. Am i right.? Please guide …
Hello everybody, I want to make an installer of my VB6 app so that it installs all the required files, create database, tables, Stored Procs in MSSQL 2000. Is there anybody who can give me some idea on this? 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 …
Hi all, I have two MS-Access Databases. 1.Comp with fields CID, CName, CMarks. 2.Stud with fields SID,SName,SMarks. I use JSP to build the form in NetBeans. I want to create a form which would allow me to choose a CName from a drop down menu. When I submit, it should …
Hi everyone , Just joined the daniweb when looking for RSA vb.net code. great site. I work in the travel industry by day, the 'hb' in hbmichael stands for HelpBeam, which is what i do at night. Its a remote support service like GotoAssist Express or Logmein Rescue. BTW, I'm …
hi i have aproblem i have atable in database and the table has three colums branch_no branch_nnnno distance 1 2 5 1 3 7 2 1 5 2 4 10 3 5 15 4 5 5 i need aprogram by vb.net that find the shortest path between any two nodesw
Pls i want to generate two report from my database one for duplicate of record based on thumbprint the other for original thumbprint using VB6 and sql server.I need the code.I will appreciate your help. i mean i want to track duplicate of thumbprint in one table and distinct of …
Hi folks, I have a system for an auctioneer and have on the form I have the fields: lot (the item), reserve price ([Reserve]) and minimum successful bid so far ([Min]). There is then a text box for the user to input their bid ([Bid]). I have set up a …
i want to use Crystal reports to generate my reports. how can i connect to the server. i am using SQL server as my database with vb6
Hi. Can anyone tell me how to find and install IIS? I need it for developing my mobile application with SQL Server Mobile and create a database. Or if you have any suggestions... Do you know any other way on connecting from mobile applications to databases (other than MS SQL) …
Hi. Can anyone give me an idea on how I can create a search box just like a search box in the contacts window in a Nokia phone?
I made a simple program in which will connect to ms sql... then, after running the codes something is error! can you help me to solve this out... here is my code: import java.sql.*; public class connect_sql { public static void main(String args[]) { Connection con = null; try { …
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 guys, I am a student on placement and I have created a database for a company. This database contains customer details, enquiries, orders and product details. I used joining 'line' tables to solve the many-to-many relationship between some tables but now i am having trouble using them. I have …
The End.