General Forum

hello friends, i have few table like create table Employee ( emp_id INTEGER(6) PRIMARY KEY ,emp_name varchar(25) not null, emp_phno INTEGER(12), emp_desig varchar(15) not null,emp_password varchar(8)not null); create table Project( proj_id varchar(6) PRIMARY KEY ,proj_name varchar(25) not null, est_time INTEGER(10)not null, est_cost...

Hi all, I'm new to the forum... I have hundreds of sets of PDFs, they are names 1,2,3...7 each in its own folder. Anyone know how ascript or a program that can take all 7 PDFs in each folder, merge them to create one PDF, and save it to a new folder (one inside the main directory)? I will actually need to add several more PDFs into the...

hi. ok, so here's my problem: i have two tables, say users and items. each user has multiple items. i just want to select one of the items along with the information in the users table, for each user that has at least one thing in the items table. i would also like the item randomly selected if at all possible. thanks much!

I am trying to configure an ODBC connection to a MySQL 5.0.12 Beta-nt instance. However, on testing I get the following error; Lost connection to MySQL server during query If I try to connect via cmd I get the following error; ERROR 2013 (HY000) : Lost connection to MySQL server during query The strange this is when I disable Norton...

Hai i am searching a database (in ms access ) to validate user info.it has two fields username and password. here is the coding and i get compile error:Method or data member not found.please help Private Sub Command1_Click() Set ch = ADODB.Recordset Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program...

I'm working on Microsoft Access. I have a form which views the record of one table. Inside the form, there are several columns. Now I want to sort the records with using combobox. Eg. if the value of the combobox is "Date" then the record is automatically sorted by date itself, if "Name" if chosen then the form will be sorted based on the name... ...

ok..so I can get all of the other information from my database, but when i try to get images, it displays as a code i dont recognise. here is the query: <?php // Connecting, selecting database $link = mysql_connect('localhost', 'username', 'password') or die('Could not connect: ' . mysql_error()); echo 'Connected successfully';...

Hi, I am trying to run the following code -: DataAccess Layer Function-: public DataSet getContacts(string Country, string Product) { DataSet dsContact = new DataSet(); dsAdapter = new SqlDataAdapter(); string conString= ConfigurationSettings.AppSettings; mySqlConn = new SqlConnection(conString);

:) Hi Friends, I am doing setup and deployment project for our windows application, it needs a custom diloguebox in which user will select option wether he want to install database or not. if he selects the installdatabase option then programm should install DB with application . can any body help me in this expecting...

I have a table with a hyperlink field to Word documents. How do I call the application (Word) and print the document indicated in the hyperlinked field? :confused:

hi to all, our database in ms access.we have given all the connection strings and on our local pc.it is working fine.all entries r going in database. but when we upload all files and database on server then it is giving error.now plz tell me wat configurtion n settings i shd give.so that it works properly on the internet. plz reply me...

Hi, pls could anyone help me with the script to calculate the percentage btwn two fields in a table.

I have done a create or replace view called creditcard1. If I do a "select * from creditcard1" it retrieves the data just fine. If I try to do a statement where I am listing the column names it doesn't recognize them. create or replace view creditcard1 as select pidm ,tbraccd_term_code as "Term" ,tbraccd_detail_code as "Detail_Code"...

Hi Friends, I am doing setup and deployment project for our windows application, it needs a custom diloguebox in which user will select option wether he want to install database or not. if he selects the installdatabase option then programm should install DB with application . can any body help me in this expecting good help thanku all

hello all, i want to share my problem with u all.my problem is i ve created two tables the primary key of one table is the foreign key of the other table. when i did select statement to show all the data of the first table it did not come properly so,i did some formatting like page size,linesize setting.i also did column setting by column...

Hi, Can anyone give some materials on how to write batch files. regards, naren.

well friends i have a small tip here which may be helpfull for u there may be situations where we need to use a customized dilogue box while doveloping setup and dyployment project, so u can do that simply by using custom actions . 1st create setup and deployment project... add->new project->windows application name it ReadmeDilogue now...

Assistance needed urgently! I use a Sybase Database with SQL Anywhere 9 and need to send the SQL query result as the body of the e-mail from within SQL. Here's what I have thusfar: ======================================================= bEGIN SET NOCOUNT ON select distinct

Assistance needed urgently! I use a Sybase Database with SQL Anywhere 9 and need to send the SQL query result as the body of the e-mail from within SQL. Here's what I have thusfar: ================================================== ===== bEGIN SET NOCOUNT ON select distinct

hi, i have lot of views which are registered to different hosts, in which many of hosts are not in the network. i am trying to remove all the views. the problem is some views are removed improperly, so i just want a script which can remove the views and which can unregister and removes the tag(for improperly removed views). can anyone help...

Hi I've downloaded the PDFClass library from ACG PDF and used their script to export a report to a pdf file. That was great. However what I really need to do for more than one client is take multiple pdf files generated from access and concatenate them into one pdf file. I was hoping that script would be availabe on the ACG site but I...

Hi, Can anybody tell me why my php script wont run properly unless i put it in a page all on its own? Is it antisocial? Does it want to be alone? I have put it in a page with background and links to other pages, but it wont generate a large version of a thumbnail unless it has a page all to itself. here is the php coding i've used: <td...

Hi, The following is the trigger which is failing when executing. Can you please tell me the reason why it is failing ? Trigger got created but throwing exception. CREATE TRIGGER TOBJ_U AFTER UPDATE ON TABLE1 REFERENCING OLD AS OLD NEW AS NEW

Hi! I'm looking for a good program for compression of the SWF files. Do you know where I can get it? Thanks.

Ihave two questions. 1.I am using postgresql8.0.3.Is there any concept of logswitch? 2. We want to prepare a backup machine (for disaster management) by passing only the ARCHIVEDIR directory from another online machine - both the machines have Postgresql installed. We have sent PGLOG and ARCHIVEDIR but the recovery is not successful unless...