6,934 Topics
 | |
| | I have recently developed a web based database application using microsoft access and dreamweaver. I have used coldfusion to link the database to the html webpage. The website runs successfully at my clients address. However, after transferring all the files to my university web space I receive the following error: … |
| | can anyone help me out? <?php include_once "mysql_connect.php"; mysql_connection($dbc); $select = "SELECT DISTINCT D.Title, D.FirstName, D.MiddleI, D.LastName, D.Suffix, D.Address1, D.Address2, D.City, D.State, D.Zip FROM Donor D, Pre_award P, sch_donor S WHERE Approved = 'y' AND S.Did = D.Did AND S.Scholarship_id = P.Scholarship_id"; $export = mysql_query($select); $fields = mysql_num_fields($export); for ($i … |
| | Hello guys, Can somone help me figure this out. I tried for few hrs today, but still failed to meet my expectation. In old ASP, the cookie is working prefectly, and it prevent me from rating multiple times even. It's a lot different in ASP.NET. For example, if i rate … |
| | I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and understanding of their structure. I cannot find anything akin to MySQL's mysqldump for mssql … |
| | // My JSP coding. This is stored in the following path http://localhost:8080/vennila/test.jsp <HTML> <HEAD><TITLE>DataBase Search</TITLE></HEAD> <BODY> <%@ page language="Java" import="java.sql.*" %> <jsp:useBean id="db" scope="application" class="SQLBean.DbBean"/> <jsp:setProperty name="db" property="*" /> <%! ResultSet rs = null ; ResultSetMetaData rsmd = null ; int numColumns ; int i; %> <center> <h2> Results from … |
| | Hi Guys! I am newbie to MS-SQL Server and I’ve run into a very very serious trouble. My company/organization that I am currently with is running MS-SQL Server 2000 Standard and our problem is: MEMORY Out of my stupidity I upgraded our server’s memory to 4 GIG and to our … |
| | Hello I read sessions and php but it's not exactly registering in my head that I understand it easily. On my site someone signups all is good they get their email and register sign in. I have them signup with a Desired Username, Email address and Password okay. Now when … |
| | IWhat exactly is the "unsigned" use for in sql and when should i consider using it? |
 | I have a MS SQL DB where I need to add a constraint to a filed of a table. This table is manipulated through an application... in a particular field, the integer (field data type) is subtracted from 5 to 4 or 3 whatever, sometimes a user does an error … |
| | i am trying to connect java program to mysql databse. bascically i am aphp programmer. now i want to lear j2ee so i was trying to connect to mysql database.i am getting the error as not able to load the drive thi sis my code import java.sql.*; public class tc …  |
| | Hi, i'm very new to sql so to say i'm a bit confused is a bit of an understatement! I'm tring to set up a search facility so that results from multiple databases will come from just one form. A better way of explaining would be to show an example … |
| | I have the following fields in table A: GL_ID| Date |GL_Name_VC | Amount |Period_TI|Year_SI =============================================================== 1000|31/12/2005 | Sales | -8,000.00 | 12 | 2005 =============================================================== 1000|06/01/2006 | Sales | -6,000.00 | 01 | 2006 =============================================================== 1000|20/01/2006 | Sales | 2,000.00 | 01 | 2006 =============================================================== 1000|28/01/2006 | Sales | -4,000.00 … |
| | I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | … |
| | I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | … |
| | I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales_HW| -20,000.00 | 01 | 2005 =================================================== 1000| Sales_SW| -10,000.00 | 01 | 2005 =================================================== 1001| Cost_HW | 5,000.00 | 01 | 2005 =================================================== 1001| Cost_SW | 5,000.00 | 01 | 2005 the fields above have the … |
| | I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 ================================================== 1001| Hardware| 10,000.00 | 02 | … |
| | I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales | -20,000.00 | 01 | 2005 =================================================== 1000| Sales | -10,000.00 | 02 | 2005 =================================================== 1001| Cost | 5,000.00 | 01 | 2005 =================================================== 1001| Cost | 5,000.00 | 02 | 2005 the fields above … |
| | I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI =================================================== 1000|liability | -10,000.00 | 08 | 2005 =================================================== 1001| asset | 20,000.00 | 08 | 2005 =================================================== 1000|liability | -9,000.00 | 09 | 2005 the fields above have the following datatype: Fields | Datatype =================================== GL_ID | Integer … |
| | |
| | I have a MS Access db that I use on my local machine to generate numerous reports etc. currently I am manually downloading a copy of the table from the online Microsoft SQL db which contains the data I use in generating these reports etc. I would like to link … |
| | Hi all, Introducing myself -- I have a background in Mac database programming, which migrated slowly (ughh) to Windows Access and then SQL stuff. So I can make a living at that sort of thing, but am now tinkering around with RedHat Linux 7.3 on an old IBM laptop. I …  |
| | hey, i am putting together an "egradebook" for a project in school. I need to know how to do the following: -have my login page search a table named "login" in my SQL DB and have it read an column named "access" that will say either (student, instructor, or administration). … |
| | hello, how to close all open sql server connections from vb.net? please help. |
| | Hey, I want a search of name ='Jose' to find both Jose and José, but with SELECT * FROM Users WHERE name LIKE '%Jose%' i only get Jose, in "Inside SQL SQL" an article shows this: If you want a search of name ='Jose' to find both Jose and José, … |
| | hey all i have a database containing many tables, 2 of the tables are same in attributes numbers and names but differs in tables names. one is titled [B]livecases [/B] and other is titled [B]archivecases[/B]. the two tables have a forgien key "typeid" from a table "ctype" to declare type … |
 | This is a start to a tutorial on Security in ASP.NET 1.1 using VB.Net code behind. [size=2][b] SETUP:[/b] [/size] [size=3][color=red][b][size=2]** Note this tutorial builds on/off the[url="http://www.daniweb.com/tutorials/tutorial19303.html"] Updated:Simple ASP.Net Login Page tutorial[/url] **[/size] [/b][/color][/size] [u] [color=Blue][b] Login.aspx HTML Code[/b][/color]:[/u] [code] [size=3]<%@ Page Language="vb" AutoEventWireup="false" Codebehind="Login.aspx.vb" Inherits="NorthLogin3.WebForm1"%> [color=#0000ff]<![/color][color=#800000]doctype [/color][color=#ff0000]html public [/color][color=#0000ff]"-//w3c//dtd html … |
| | I like to use sql procedure to java code how i connect it to my project please send code to be more obvious  |
| | Hi I have borrowed your ASP.Net login page code and have tried to get it working. It all seems ok and I have made adjustments for my database and a asp:login control instead of textboxes. Visual Studio 2005 doesn't like the line below, saying CommandBehavior has not been declared. I … |
| | Hello, I'm pretty much a newbie with SQL. I have a database that is growing out of control and I'm unable to delete any records (data) from it. I've tried numerous open source applications but nothing has worked. The database is with a hosting and they provide ASP.NET Enterprise Manager. … |
| | Hi, 2 days ago my computer got hit by the amaena / winfixer problem. I haven't been able to sort it out until tonight though. I read through other threads to help me find a solutiion and I followed the advice for running Hijack This and also for running ewido …  |
| | Hi everyone! I am desperate to find an answer to this problem. I have read through (and tried to use) anout 6 different tutorials, but I just cannot fix this. It would mean so much to me if someone could tell me what I am doing wrong, my brain is … |
| | :-) Here's another one that's bugging me.....again in VB.NET 2005 and windows forms. After selecting an account from a dropdownlist, I am populating a datagrid with items that correspond to that account. Really, I just wanted to display a summary of the items in the datagrid, and then pass the … |
| | I have tried every avenue I can think of, but this forum seems to be the best to supply help. I am creating a class using NetBeans. I have created the following code, but get an error message for the line "public static Connection getConnection (String strFileName, "","") throws Exception. … |
| | Scenerio. I am extracting Primary key from Listbox to read against the Products Table in Northwind database to populate the textbox controls. This particular column "UnitPrice" is giving me this error message:- " Cast from string "Display" to type "Interger" is not valid". Can someone point me to the right …  |
| | [B]Hi everyone! Nice forum you have here, I was looking for a forum like this for a long time.[/B] [B] [COLOR=DarkGreen]I have an important issue. We had a website and a stand-alone phpBB forum script. Today, the guys wrote a whole new website based on php-nuke cms, with included forum. … |
| | I've been working on a production DB on a POS and Inventory System for over a year. That's over a year of data and along the way, I took that system and implemented to 4 locations and 4 individual servers. I've major software updates and Schema changes (adding Views, SP, … |
| | Hi I am trying to delete a name from my database however my code seems to have a problem. It seems to cut out before i actually excutes the SQL statement. Is there something else i have missed in the code. PatientNumber is equal to the value to the text. … |
| | Hi guys, A problem occured when i tried to run the php file. The error was; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\)' at line 1 Plz guys help me to … |
 | hi, i have a popup which asks for a date. when clicked, it will close and display the records created on that date on a new page. the format passed is d/m/yyyy. a portion of my sql is as follows:[INLINECODE]sqls=sql&" WHERE pr.DateCreated LIKE '" & datec & "'"[/INLINECODE] where:[INLINECODE]datec = … |
 | Hello, hello... I've done a little bit of spyware annihilating and whatnot, and I guess I have a fairly clean log now; but seeing as I am not a professional, I cannot be too sure that my log is 100% clean. Anybody care to check it for me please? [CENTER]~~~~~[/CENTER] … |
| | Hi, I am having a table with 16 lakhs records in it. Each record contains approximately 50 columns. I am using MSSQL Database. Basically the table contains details of the user's registration details. I have a application built in VB.net which will be selecting a random user_id and then searches … |
| | hi, im a newbie and im developing a system using ASP.NET programming using visual studio and SQL Server.i was tring to write my first login page, and i connected it to the database, and ran my application.but this error came out,"[B]error while trying to run project:Unable to start debugging on … |
| | Hi all, Im executing db2 export command using shell script. I want to check for error status in the script. if db2 command fails due to some sql error, shell script should log error msg and the script should not run further. i would like to know shell script command … |
| | Hi. I am working on a particular sql statemtent that looks like this, but I simplified it greatly. [CODE]x="INSERT INTO TableA (T1.Key,T1.Field1,T2.Field1,T2.Field2,T3.Field1,T3.Field2) FROM (T2 RIGHT JOIN T1 on T2.Key = T1.Key) LEFT JOIN T3 ON T1.Key = T3.Key"[/CODE] That is how Access created the statement. All 3 tables have the …  |
| | hi im new to this ....but have read a few posts about this trojan.cachecache kit thing. Although this is not my computer i am trying to sort it. A trojan keeps coming up an an autoprotect window .. i take it somehting to do with symantec antivirus .. but when …  |
| | Hi all, Has anyone ever tried creating a form in infopath that collects timecard data (hours worked, etc.) then, when the user clicks "Submit", the information gets posted to an SQL database? This is probably fairly easy, but my feeble attempt failed horribly today. If any knows of a link … |
| | Hi all, Has anyone ever tried creating a form in infopath that collects timecard data (hours worked, etc.) then, when the user clicks "Submit", the information gets posted to an SQL database? This is probably fairly easy, but my feeble attempt failed horribly today. If any knows of a link … |
| | Ich transferiere gerade ein Hosting von einem alten auf einen schnelleren Server. Gleichzeitige Versionsänderung MS SQL Server von 6.5 auf 2000. Dabei habe ich mit einer SQL-Abfrage zu kämpfen. Und zwar sieht die folgendermassen aus: SELECT COUNT(*) AS nrecords FROM ABData WHERE (0=0) AND (MARKE='Dodge') AND (Rubrik='Autos') Cold Fusion meldet … |
| | Hi all, Ok, first I'll let you know that I am very new to databases and scripting languages, so my questions are very elementary. I have read a book on the SQL language as well as a book on PHP basics, but I have no idea where to get started. … |
| | [code] CREATE TABLE my_feature ( pk_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, member_id INT(8) UNSIGNED NOT NULL, time_added DATETIME NOT NULL, personal_questions BOOL NULL, hits INTEGER UNSIGNED NULL, PRIMARY KEY (pk_id)); [/code] When I put this into the MySQL Query Browser I get this error: You have an error in your … |
The End.