6,934 Topics
 | |
| | Hi, I am wodering how to store and retrieve czech, or other utf-8 related language, characters using IIS 5.0 and SQL server 2000; I try to explain: at the beginning I was using the 1252 default codepage (with no charset specified) and some character was immediately changed when posting toward …  |
| | I am doing an SQL statement that tries to get the [B]percentage[/B]..but i dont know how to do it in MySQL here is the sample of my code: SELECT count( * ) , rating, percentage.... FROM `acne_prod_rating` WHERE prod_id =5 GROUP BY rating the output should be like this: count(*) … |
| | I have a search code from Database. i want to display queries from Database with multiple option. how do i assign variable on both. for example String jsql= "Select * from UserList WHERE '"+abu+ "' = '"+userSearch+ "'"; the full code: <%@ page contentType="text/html; charset=utf-8" import="java.sql.*, java.util.*" errorPage="error.jsp"%> <html> <head> … |
 | [B]How to search a database[/B] [B]Intro[/B] Searching a database is actually a easy thing. It just involves a form, and a page that displays the results. Im going to show you how to make a simple form, and a page that displays the results. [B]First steps[/B] So the first step … |
| | Hi there I need to create a command line interface in java. I have something that connects to an oracle database and allows me to do a predetermined select steps. I need some sort of java code that will allow me to have a prompt: Which you like to do? …  |
| | I have a windows nt server with sql 7 installed and am getting the following in event viewer. The product Microsoft SQL Server 7.0 is out of licenses. Use License Manager from the Administrative Tools folder for more information on which users are out of compliance and how many licenses … |
| | Hi everyone! I am trying to develop an application to communicate with a Microsoft Acces database. For doing that I import the java.sql package to use the DrvierManager class to get a connection. The problem seems to be the application doesnot find the java.sql package. I have the 1.4.2_08 version.. …  |
| | I have a SQL query: SELECT * FROM Job_Request_Record, Requester_Record WHERE Job_Request_Record.Job_Requester_ID=Requester_Reco rd.Requester_ID; if i want to call an attribute from Job_Request_Record table e.g. rs.getString("ID")is it valid? or anything else. please help. Also, is it possible to have a create view table in ms access 2003? |
| | Hi. Does anyone know how access data stored in Visual Fox Pro 6.0 (ancient, yes) through asp.net? I've read conflicting information, saying I need to use ODBC connections, but that doesn't work -- after I make my connection to the data table, I get an error on my command.execute saying … |
| | [COLOR=DarkRed]Hello, I am Software Engineer and Working in Visual Basic 6.0, SQL Server 2000, Crystal Reports, Visual Foxpro 6.0 etc... Please consider me when u have some information or I need information about theses tools also from You...[/COLOR]  |
| | Hi, I am trying to amend a single record in an Access database, the SQL to find the record appears to work but .... when it updates, it does so to every record in the table. Any suggestions why this might be? :-| Thanks, Stephen  |
| | Hi, We have a accounting/inventory program that uses MS SQL as the database, with VB and Access for reporting. We want to make the database available online. ie.. Our clients can search the inventory and make orders from it. We do not want to install a local web server inhouse. … |
| | Hello Everyone. My Name Is Michael, I am 22, From Ontario Canada. I have a Wife and One Child, I run while at least try to run a Web hosting business that should be launching this week we are all hoping. I know what some of you may say, that … |
| | I want to create table at runtime of my VB code.At first i have used SQL command to do this. At first it worked properly, but now it has gone to worse & no table can be created. I am using MS Access2003 & Visual Basic6. Your help will be …  |
| | First of all thank you for the example on how to create the login page. I am also new at this and I have been trying out the login page using a SQL db. I am getting an error on my code for the button click event. If Page.IsValid Then … |
| | hi guys i've posted this on both the SQL and ASP.Net forums cause i ain't sure which one i should use so sorry about clogging up the message board. Basicly i'm a newbie with ASP.net and i was looking for somw help with this query i got a site and …  |
| | I'm in the beginning stages of designing a mechanism to share and integrate data between 2 software systems. Each software system uses a large scale relational database. One is written in asp/vb and uses sql server 2000. The other, i'm not familiar with the specifics, but I want a solution …  |
| | Hi, Accidentally one the member has compressed the disk drives in the SQL Server. Before we go ahead an uncompress the disk drives, we need to make sure that the database is unaffected. 1. What is the normal database compression ratio when Hard Disk is compressed? 2. Do uncompression of … |
| | Hey folks, I need your help. I stuck with my Database project. I have five tables on the database: These are Room, Guest, Booking, Employee and Admin Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address,…) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, user_name, password) Employee …  |
| | hi to all, please do suggest me y this error? 0063 $result = mysql_query($sql) or die(mysql_error()); 0064 0065 [U]$admine-mail = "admin@yoursite.com";[/U] $adminpass = "admin"; $adminname = "Admin"; $sql = "INSERT IGNORE INTO cms_users VALUES (NULL, '$admine-mail', '$adminpass', '$adminname', 3)"; $result = mysql_query($sql) or die(mysql_error()); [B]Error :[/B] Parse error: syntax error, … |
| | [CENTER][SIZE=5][B]Catching Up[/B][/SIZE][/CENTER] In The Previous Tutorials, we have covered a lot of information. We've gone over a few of the functions of the CGI.pm, and and figured out how to retrieve information from a web page form, submitted by the user. However, reading this information, and thanking them by name … |
| | Hello, Can anyone explain to me how I can create a function that I can use in SQL. Thanks |
| | Hi Everyone, I want the user to select via a checkbox for which employees to print a report. I understand that on a continuous form checkboxes need to be bound to an underlying field. I want the boolean field bound to the checkbox to reside in a WORK table, that … |
| | could someone provide me with the sql for the following code: Dim i As Integer Dim countvar As Integer If Number_of_Panels.Text > 1 And Number_of_Panels.Text < 27 Then For i = 1 To Number_of_Panels.Text countvar = (countvar + 1) Project_Number.SetFocus MsgBox Project_Number.Text & countvar Number_of_Panels.SetFocus Next i Else End If … |
| | [I]Link removed due to illegal content. If you feel this change was made in error, PM me with proof of legality. -Narue[/I] This site contains 1700+ ebooks on php, Java, access, .NET, c#, UML, Perl, c++, linux, sql server, asp.net, Oracle, db2, xml, javascript, unix, flash, cisco, excel. |
| | How to set or unset IDENTITY Property of a column through code or stored procedure for Sql Server 2000. We are adding some data into a table and then wish to set the Indentity property thr' code or stored procedure. Any help appreciated. Regards [Sham] |
| | Im using an ADO data control to connect to an Access database .mdb I can set the ConnectionString property correctly, but when I set the RecordSource to an SQL statement such as an INSERT statement in this format INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) it doesnt work when … |
| | ok its one of those things i can't get my head around it at all.. i dont know if it the code i have already thats causing the problem or the fact that i dont know how to do MOD properly.. :( its causing bad gray hair.. :( so if …  |
| | I'm currently a 4th-year CS major. This is not to say I took many CS courses, but I still need to take classes on Operating Systems, System programming, S/W Engineering, AI, Database, etc. So, far, my programming skills are pretty trivial. I know C++/Java but can only write simple trivial … |
| | i'm having a problem with my SQL query. i'm trying to create another column with values based on the values of the other columns and call it sTitle. Every time i try to execute my SQL statement it brings back this error: Illegal mix of collations for operation 'concat' Error … |
| | Dear friends! We are asking your opinion on alpha-version of our MySQL Client Some people ask what is the point of yet another My SQL client (there are dozens of them). We see our niche as low cost solution-a set of several tools with everything a web-master might need. It … |
| | I have a form on my site where members fill in info etc... This info goes into my database, I call to my DB to display this info in a table. My problem is that when someone does not fill in one of the spots in the form this goes …  |
| | I've got a query set up that generates a resultset of players and their statistics, and this is displayed back out in a table via PHP: [B]Query: [/B][php]$sql = 'SELECT nickname AS name, count( * ) AS played, sum( score ) AS agg, max( score ) AS highest, min( score … |
| | hello... any one have any idea about sql injuction....how i can retrieve database from any site.. Raza. [email]hasnainr1@yahoo.co.uk[/email] |
| | could someone please check my log file from hijackthis v1.99.1. and tell me if i need to remove anything else. I had no choice but to use the uninstall program provided one of the members here, but it seem to have worked, but not sure that it might have left …  |
| | I change query parameters in my code. i want the query to change her Sql property to new sql with new parameters. Set QueryDef = CurrentDb.QueryDefs("q_QueryName") QueryDef.Parameters("[Param_1]") = stringvalue_1 QueryDef.Parameters("[Param_2]") = stringvalue_2 QueryDef.Parameters("[Param_3]") = stringvalue_3 QueryDef.Parameters("[Param_4]") = "#" & Format(timevalue_1, "HH:mm") & "#" QueryDef.Parameters("[Param_5]") = "#" & Format(timevalue_1, "HH:mm") & … |
 | Ok this is a pretty recent problem i am having with my windows xp. When i load the operating system a program called cisvc.exe or someting close to that runs.for a while everything is alright but then this program starts eating up my cpu ussage. If i shut off the …  |
| | Hello, I am attempting to make a stored procedure call to an ADO. I will paste in the try loop. Problem is code compiles and runs, however; the stored procedure never runs. It's supposed to create a row in the DB, and the row is never created. If I run … |
| | Recently I had been infected by this virus that try to write 2 files(autorun.exe and autorun.inf) whenever I insert a CD into my cd-rw. I've manually removed most of the files which is hidden. When you run the autorun.exe file, it will create a file called Crazy-Frog.html and a bunch … |
| | I'm a newbie with inputing into a database. Can someone help me with the script below. There is probably a few errors. Can you spot them please :) Thanks in advance Dim conn, rsadd, sql Set conn=Server.CreateObject("ADODB.Connection") conn.Open "seneca_book_db" Set rsadd=Server.CreateObject("ADODB.RecordSet") sql="Select * From Customers" rsadd.Open sql, conn rsadd.AddNew rsadd("Custaccount")=request("T3") … |
| | hello i just joined the forum. i like computers and i think i would be of some use as a tech but mostly i like programming i'm a real amateur at it but iw ill stop at nothing to learn all i can learn. i like trying new things because …  |
| | Hi, Trying to clean up my machine, I've already ran Spybot, AdAware and HJT and got rid of lots of stuff but there's a few things which just keep coming back. IE keeps opening with the following URL [url]http://67.15.70.15/~black/f***porn.html[/url] and there's several processes which I haven't been able to remove. … |
| | Hi All I am facing problem is SQL Server 2000, with OPENXML. I am having data which i receive from some other database in form of xml doc. Now I have to use this xml data as JOIN with MS SQL 2000 database table. But as everybody aware that using … |
| | Hello all, im writing a c++ program to interact with an SQLServer database. my code will run a query and retrieve data fine. for example SELECT data FROM TestTable returns all strings from the data column. but when i run the following statement INSERT INTO TestTable (data) VALUES ('HELP') i … |
| | Hi All, First post and would appreciate any help. I want to start a forum at work. The IT department have quoted an unreal price. Can someone please tell me in idiot terms what I would need and an approximate cost to get it running. For instance, I understand it … |
| | Hello all, I am a prefinal yr student of IT. In our next semester we have sql. I also want to learn oracle as it is in a great demand. But what is the difference between them. You can also suggest me on how to start with oracle (some books … |
| | Hi, I am very very new to ASP. So far i have been able to connect to the SQL database using dreamweaver mx 2004 but im not sure where to go from here. I have a support databse that i have setup with a few records. The table structure looks … |
| | Hi All I have the following requirement to be implemented in PHP & My SQL database with Apache Server. I have to write a PHP which will get a HTTP request from Client and immediately respond back with a Token # (Random number). Once the Token number has been sent … |
| | hi, in order to install my php gallery, i have to "Run the photos.sql script in your MySQL database" what does this mean? i know i have mysql, as i have a phpBB2 forum running. but how do i do this? thanks |
| | Hi.. I have done some programs in VB6 (SQL Database). With the Crystal report (Vertion 4). Now I wanted to do these things with Crystal-9. But the procedure to pass values to “Formulas |
The End.