6,934 Topics
 | |
| | Here is the code I use in the World recipe random record. I've been looking all over the net on how to display random record using access db on ASP .NET, but found most for SQL server like NEWID(), doesn't work on Access. This could be easily done in ASP … |
| | This sql command is for PHP but this is what happen to it after php had made chenges: [CODE]UPDATE Catalog SET Table='Harrow_VH' WHERE Name='Variable Action Harrow'[/CODE] I get this error both places php and mysql client it self: MySQL said: You have an error in your SQL syntax near 'TABLE … |
| | The MS SQL 7.0 Server is installed on a Windows server, not placed in my home. I want to make a SQL query from my home, using java JDBC, but I get an error: java.sql.SQLException: Network error IOException: Connection timed out: connect - This error I don´t get if I´m … |
| | I have major lag on my computer, espeially when im playing online games. It would be very helpful if somenone could have a look at it for me. Logfile of HijackThis v1.98.2 Scan saved at 21:43:41, on 22/07/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) … |
| | Please help me in ASP is support many style of ContentType = "video/x-ms-asf" ,"vnd.ms-excel" ... but not support style foxprox (.dbf) I want to use SQL select database and export to file dbf Thank you ! |
| | Hey all, Heres the code of an ASP I'm working on... ------------------------------------begin ASP------------------------------------- <%@ Language=VBScript%> <% artist=Request("artist") album=Request("album") Set con1 = server.CreateObject ("ADODB.Connection") Set rs1 = server.CreateObject ("ADODB.Recordset") con1.Provider="Microsoft.Jet.OLEDB.4.0" con1.Open (server.MapPath ("\databasecore\mediaguide.mdb")) sql = "UPDATE artistinfo SET UserAlbumReview='"&TRIM(Request.Form("AlbumReview"))&"' where artist ='"&artist&"' and album = '"&album&"'" rs1.Open sql,con1 %> <html> <head> … |
| | Hello everyone, I am new to mySQL. I want to know how to use mySQL with c#, and if there is any difference between MS SQL and mySQL. Also any links to tutorials would be great. Thanks |
| | I got this error: "PHP Parse error: parse error, unexpected T_STRING on line 137" from the following code and I am not sure what is wrong iwth it. Any suggestions? <html><head><title>RealProphet.com </title> </head> <body> <table border="0" cellpadding="5" cellspacing="0" width="100%"> <tr> <td width="100%"><!--webbot bot="Include" U-Include="../include_head.htm" TAG="BODY" --> </td> </tr> </table> <table … |
| | hi guys, iam just started with VB.NET and i really like to be a programmer please advice. it will be fine to learn about connecting with database i already had a good experience with VFoxPro(but not the sql connection). and i like to to make reports inside a web page …  |
| | I hope someone can help me. I have already done all the queries which I need it thanks to your forum. Can someone tell me how to make a listbox where I can use my SQL Query, but date to be puted by myself. Example: USE NAIM GO SELECT Nr_Amez, …  |
| | Hi, I am in the process of deciding the database and application language. We have exising MS SQL server running on windows OS, to save the company's product data, right now I need to build another seperate system for intranet use, as I am more familiar with PHP+Mysql, I want … |
| | I need a help. I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date. Does anyone have any idea how to solve this problem. |
| | Hi everybody! I am having a strange problem, Im working with a remote access database, i have one application to introduce info to de database and other for making a query. The firt one works perfect...but in the second one the application jumps to the error code when tries to …  |
| | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in _____________________________________________________ I have seen a lot of this around the internet lately, both in forums and on some production websites (WHOOPS!) :cheesy: I am currently developing a small site which uses MySQL as it's data repository, and I … |
| | hi, please help me ... how to create dynamic menu using vb.net (webform)?? and my menu should be displayed base on data on the database. i'm recently using ms sql ... thanks for your helps |
| | SELECT NZDate - CAST(NZDate - '2005-01-01' AS int) % 7 AS WeekStarting, sum(score)/7 from myTable where (NZDate between '2005-01-01' and '2005-01-21') and name IN ('John','Bob','Harry') group by NZDate - CAST(NZDate - '2005-01-01' AS int) % 7 order by weekstarting Hi, I have a query (above) that given any start date … |
| | i tried to insert data from a form using jet now everythign wirked fine apart from it refusing to handle db fields with auto increment my db lookes like this id:auto increment text:text date:date the sql looked like this INSERT INTO table(text, date) VALUES('" & text.text & "', date()) resluting … |
| | anyone can help with data navigation in vb and ms sql 2000?  |
| | I am having some trouble with pop under ads. They seem to pop up randomly (It can go days without happening) and they are popping up even when I am not surfing the web or using IE. The most frequent time they pop under is right when I login and … |
| | Hi, all! I need to load base from ODBC-source into MSSql base using MsSql DTS at my customer's side with automatic as much as possible('Pushing 1 buton'). I have found such an example: DECLARE @object int DECLARE @hr int --create a package object EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT … |
| | Hello there, we are converting our applications from a sybase server over to MS SQL Server 2000 and have run across a query that is acceptable in sybase but not ms sql. It is giving us a table name correlation error that we can't figuire out. In sybase the sql … |
| | Hello, I have two questions, first some background info: We are running SQL 2000 on a Windows 2003 server for out aircraft parts database software. There are 7 workstations (windows 2000 and XP) that run the parts database. 4 of those workstations run really fast, the database calls are near … |
| | HI 1. I have a typical problem.We have a 2003 server which is a user authentication server.I have a sql server 7.0 on NT platform.I am logging in to the 2003 server from my XP workstation. 2. I am authenticated to 2003 server & simultaniously to NT server which has … |
| | My Anti-virus keeps finding a couple of problems, so does Spybot and Ad-Aware occasionally. Hopefully it's not too bad but I'd appreciate any help. Logfile of HijackThis v1.99.1 Scan saved at 21:47:33, on 24/06/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe …  |
| | im new to vb, i need to use vb6 to connect to local sql server with the local system account and get all the databases. ill be very thanksfull for any help. |
| | Please help !!! I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized company which does not have an IT dept therefore I … |
| | I wrote a JSP page that connects to a Oracle database. I did a SELECT statement to find out procedures and I printed the procedure into a form. In this form I can modify the procedure and save it. Then I created a sql statement to modify the procedure and … |
| | Greets from Portugal (Nope, It's NOT Spain (Yet) or Africa (Guess we're closer to Africa then Spain, but ... it's like ... details :eek: ) I'm graduating in Computers & Programming, have some skills in the electronics and automation field, networking, programming (mostly in VB(.Net) C(#), Java, Pascal(Delphi)) SQL(my & …  |
| | Here is my [b]Stored Procedure [/b] stored in SQl DB. [code] CREATE PROCEDURE qparmVerifyLogin @First_Name varchar(30), @Last_Name varchar(30), @SSN varchar(9) AS Select First_Name, Last_Name, SSN, ADDRESS1, CITY, STATE, POSTAL, DEPTID, EMPLID FROM PERSONAL_DATA_TBL WHERE First_Name = @First_Name AND Last_Name = @Last_Name AND SSN = @SSN; GO [/code] [b]Below is the … |
| | hey all, i've worked with sql server 2000 before and configured the odbc driver to connect to it, using tcp/ip, named pipes, sql admin (sa), and so on....now we're starting to get involved with mysql and are trying to configure myodbc to talk to mysql so queries and tables and … |
| | hi im a newbie in asp.net(learn 2 days ago) n still havent fully grasp the concept of asp.net yet. I ran into some problems here but i dunno what is it. i've tried looking at the other post but could not really find the error in mine .Can you please … |
| | How about a forum for web application security? I'd be interested in discussing security issues related to writing web-based applications, as well as security concerns regarding existing web applications, such as vBulletin. I'm talking about things like cross-site scripting vulnerabilities, SQL injection, form input manipulation, and authentication/authorization techniques. |
| | I've been having continuing pop up problems for weeks now. It started with a "surf" something or other .exe file, which I deleted / fixed usunf hijackthis etc. Now I still have this pop up ...but can't delete it. I'm also getting "pocker" and "casino" icons popping up onto my … |
| | Hello and thanks to anyone who can give advise. This virus has somehow infected my computer at work which is on a network but I believe our network is safe. I can't get rid of this damn thing cause it keeps regenerating. Any help would be greatly appreciated! Logfile of … |
| | hey guys, i don't program at all , i just run and maintain the servers,so i really don't know much about php but my manager is trying to create web based bill menu for our company using php. he wants to be able to create a user, without being logged … |
 | i got this message plz help :: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/baje/public_html/Templates Management/index.php on line 17 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/baje/public_html/Templates Management/index.php on line 19 its like this plz point out session_start(); include_once('common/common.php'); // … |
| | Can anyone tell me how or what's the code for the following: 1. I have two frames on my web page. (Top and Bottom) 2. Top Frame is data 3. Bottom Frame are some Controls. (Print button, Back Button, Close Button.) 4. I [B]do not[/B] want to use Java. 5. … |
| | I am just going to throw this out here and see what responses I get. Is there any tutorials any of our members would like me to post in the .NET Tutorial Section? Login (done) Registration (done) SQL vs Access DB backend (done) I was thinking of possibly a datagrid … |
 | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/user/public_html/im2db/image.php on line 14 This is the error I am getting Here is the code: Image.php Am I supposed to add a exit(); after $result = mysql_query ($sql, $conn); line? [PHP]<?php // database connection $conn = mysql_connect("localhost", "user", … |
| | Hey there all, i have a question about how to point my python install to my sql database. when i enter this:[CODE] db = MySQLdb.connect(user="user", passwd="pass", db="myDB")[/CODE] i get this: [CODE]Traceback (most recent call last): File "<pyshell#1>", line 1, in -toplevel- db = MySQLdb.connect(user="user", passwd="pass", db="MyDB") File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 66, … |
| | Is there a way to drop a PK from a table by selecting the name into a variable from all_constraints, I need to run this script on multi databases that the actual name of the PK could possibly be different. I can get the name in a variable but don't … |
| | Hi All, I am currently trying to create a perl script that takes sql statement that is stored within text files and add up the frequency for that sql statement in that text file and store the sql statement and the no of frequency in another file. Below is a … |
| | hi, i have created a class called TNote this is my class: TNote = Class(TObject) NoteID : Integer; Descr : String; Note : String; CreatedByIDF : Integer; DateTimeStamp : TDateTime; ApplicableUserID : integer; end; TNotes = Class(TList) Note : TNote; procedure ClearList; procedure RetrieveFromDB; overload; procedure RetrieveFromDB(AWhereClause: String); Overload; procedure … |
| | Hi All I need help and i am new to php so bare wih me :confused: what i m tryin 2 do is that add poduct shipping handeling togther to get an avraged rate so this is the part of code Troubling me: [CODE] $nrow = mysql_num_rows($result); if ($Vh4 == … |
| | i am trying to figure out how to flag a value in my asp, sql 2000 db web project. i have one accepted time, "6A-2A", and i need to allow my salesstaff to enter in any time slot(s). i have to flag a time slot which lay outside of the … |
| | Hello all, I have a MS SQL database which is meant to be quite small. For some reason it appears to have grown to 1GB in size. There are quite a few tables in the database. Is there any way to get a report (using enterprise manager) of the table … |
| | going crazy over here!!! If you will notice in the bottom left hand corner the ProductCategoryName Column is producing two and three results on the same product and these products are not in the categories table, this categories table is where the ProductCategoryName is at so i am not sure … |
| | I have the following code, which tries to see if someone selected a drop down menu item that is already part of the database. If it is, then the error message should show up. [PHP]$size_of_user_array = count($user_selects); $size_of_db_array = count($already_in_db); for($y=0;$y<$size_of_user_array;$y++) { $input = $user_selects[$y]; for($r=0;$r<$size_of_db_array;$r++) { //echo "Already in … |
| | Hi all First of all i m still new 2 php so please help me out. I am makin an small shipping system using php and i want to make it so that when people submit zipcode the form should only submit the first two digits instead of whole thing … |
| | Non of the java programs which used to run fine in my computer has stopped running. There are no errors in da programs as they still run fine in other computers. All programs gives the folllowing error "Exception in thread "main" java.lang.NoClassDefFoundError" I set my classpath and the path fine … |
The End.