Database & SQL Forum RSS Feed

How to customize prompt confirm message box for web input report?

Fri, 03 Jul 2009 07:38:30 -0700

Background
For web input report, users often need input data at the client-side. Then, if a prompt message box will appear when users submit input data to confirm submit success, it will be very convenient.

Sometimes, users have to customize prompt message box according to real requirement. Then, how to achieve it?

Solution
RAQ Report is a professional Web-based reporting tool pays a lot of attention to users’ requirement. Therefore, users can solve all the common problems in web report easily with RAQ Report. Such as radio button for single choice or multiple choices, drop-down list, automation computation, automation sequential number, data validity check, and batch operations, etc.

For this problem, RAQ Report provides a wonderful solution. Therefore, you can easily customize prompt box with RAQ Report. As it is a pure Java reporting tool,you only need to write JavaScript Code in a JSP file.

For example, if users want to add “cancel” in the prompt message box, they just need to set “cancel” as the value of promptAfterSave.

The JavaScript Code is as follows:

<input type="submit" name="Submit2" value="submit" onclick="firm()" />
function firm()
{
// Use the return value of prompt box（true or false）
if(confirm("NeedSave"))
{
//If true is selected, call _submitTable( report1 )
_submitTable( report1 );
return true;
}
else
{
//Or else cancel it;
//alert("If false is selected, false will be returned");
return false;
}
}
</script>

Graphic Illustration

Designing a database for a Bible

Wed, 01 Jul 2009 09:21:55 -0700

I am wanting to create a new “PHP Bible.” I have the Biblical text in something similar to xhtml.. Each word is tagged with the original Hebrew or Greek word.

My question: what is the best way to set this up in a MYSQL database? I obviously need to be able to search through the text quickly and read the tags quickly.

Thanks for any suggestions or comments!

Here is a sample of the format I will be converting from:

<verse osisID="Gen.1.1" sID="Gen.1.1"/><w lemma="strong:H07225">In the beginning</w> <w lemma="strong:H0430">God</w> <w morph="strongMorph:TH8804" lemma="strong:H0853 strong:H01254">created</w> <w lemma="strong:H08064">the heaven</w> <w lemma="strong:H0853">and</w> <w lemma="strong:H0776">the earth</w>.<verse eID="Gen.1.1"/>

SQL query needed !!

Wed, 01 Jul 2009 04:41:58 -0700

Hello Programmers..
I need a sql query similar to PIVOT transformation.
I have a table containing 3 Columns ...

STEP | Label | Value 
--------------------
1    | Good  | Enabled
2    | Better| Enabled
3    | Best  | Disabled

I need a sql query to get the results as

STEP | Good     | Better  | Best
--------------------------------------------
1    | Enabled  | NULL    | NULL
2    | NULL     | Enabled | NULL
3    | NULL     | NULL    | Disabled

Looks the query needs to display the transpose of a matrix
Any help in this direction appreciated

Srivatsa

Data Security for Oracle E-Business Suite

Mon, 29 Jun 2009 06:47:48 -0700

Recently we had a bad experience of losing live data. So with the help of Solix we started creating non-production clones of Oracle E-Business Suite for testing, development, and even training. It really helped us a lot in E-Business Suite Archiving.

FRM-18108

Fri, 26 Jun 2009 14:08:55 -0700

I have a number or oracle forms that utilize both
libraries and templates. The templates have always been
stored in the database while the libraries and forms themselves
are accessed via the file system. In updating a system
somehow a form now has started to fail compilation with the above.
Even when loading in the form designer it fails to find the template objects. When I produce the object list report I can see were it
wants to find these template objects on the file system when in
reality they are in the database. I have no idea how to tell it
to go back to looking in the database for these template objects.
I have manipulated from libraries in the base where it asks you where you would like to access them from, but the templates do not.

Any help?

INSERT dd/MM/yy format date without using CONVERT Function

Fri, 26 Jun 2009 04:35:42 -0700

hi,
I have made a software in dot net 2005 (c#) and insert date into the database using format MM/dd/yy format. Now requirement of the client suddenly change , he wants date in the format dd/MM/yy, i have change the regional setting of my computer and it changes the display of the format in the sql server but when we insert dd/MM/yyyy(25/3/2009) it gives error, is there any way out,
can we just change the setting of sql server 2000 and date is converted into dd/MM/yy???

INSERT dd/MM/yy format date without using CONVERT Function

Fri, 26 Jun 2009 04:34:01 -0700

Accessing one database from two independent machines

Tue, 23 Jun 2009 18:54:16 -0700

I am working on my first major SQL db. I want to use the same db from either machine. I am using my notebook and my desktop depending where my daily schedule takes me. I manually consolidate my files in the evening.

I can use the same directory structure, but the actual SQL installations may be a bit different. I think that is causing me a problem...but I am new at this... I can connect fine with my desktop but not with my notebook.

In summation: 1) HDD structure; 2) login? Thank you, in advance, for your time! < Steve >

Microsoft SQL Server 2008 For Dummies Sep 2008

Tue, 23 Jun 2009 05:28:23 -0700

http://img7.raidpic.com/421.jpg[/img]

Product Description
If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read Microsoft SQL Server 2008 For Dummies!

SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You’ll be able to:

* Develop and maintain a SQL Server system
* Design databases with integrity and efficiency
* Turn data into information with SQL Server Reporting Services
* Organize query results, summarizing data with aggregate functions and formatting output
* Import large quantities of data with SSIS
* Keep your server running smoothly
* Protect data from prying eyes
* Develop and implement a disaster recovery plan
* Improve performance with database snapshots
* Automate SQL Server 2008 administration

Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!

From the Back Cover

The fun and easy way® to build powerful databases

See how to administer, troubleshoot, and report like a pro in SQL Server

Are you ready to unleash the power hidden within your organization’s data to meet business objectives? This book will help you build the skills that SQL Server database administrators must have to succeed. You’ll find out how to develop and maintain a SQL Server system, design databases, manipulate data, and much more.

Discover how to:

* Build your first SQL Server databases
* Insert, manipulate, and retrieve data
* Keep your database server running smoothly
* Protect data from prying eyes
* Improve performance with database snapshots

Link :
http://uploading.com/files/GEQPSFXC/For.Dummies.Microsoft.SQL.Server.2008.rar.html
OR
http://hotfile.com/dl/7437532/7b1d633/For.Dummies.Microso ft.SQL.Server.2008.rar.html
http://rapidshare.com/files/247644958/For.Dummies.Microsoft.SQL .Server.2008.rar

Password default : www.bookitplus.net

Microsoft SQL Server 2008 For Dummies Sep 2008

Tue, 23 Jun 2009 05:27:20 -0700

row index

Mon, 22 Jun 2009 18:01:54 -0700

how can v find the index of a row in vb.net 2003. I guess dere's a method called "indexof" in vb.net 2005 n higher versions but how 2 do it in vb.net 2003, sum1 pls tell me.

Generic database GUI for input

Mon, 22 Jun 2009 15:48:46 -0700

I am looking for a GUI to access a database without having to write the whole thing. Any ideas? Thanks!!

Non-SQL accessing an SQL database

Mon, 22 Jun 2009 15:44:18 -0700

OK - maybe a dumb question... I decided to write a desktop database application to include GUI interface. I am using C# and SQL. My question: Can I access the SQL database using direct code? i.e., access it through an array [x,y] instead of having to use the SQL language? Thanks!

SQl views

Sat, 20 Jun 2009 22:58:26 -0700

Consider the following few relations of Academic systems.

Here we have data base design with little bit changes and is limited
to four relations.

PROJECT ( PROJ_NUM, PROJ_NAME, PROF_NUM)
PROFESSOR ( PROF_NUM, PROF_FNAME, PROF_LNAME,
PROF_HIREDATE, JOB_CODE).
JOB (JOB_CODE, JOB_DESCRIPTION, JOB_CHG_HOUR)
ASSIGN (ASSIGN_NUM, ASSIGN_DATE, PROJ_NUM, PROF_NUM,ASSIGN_HOURS)[/color]
A. You are required to write the VIEWS for the following situations.
Create Views that List Professors’ current Responsibilities & roles
information in University.
1. (Name View: Views_One)
List columns name as Professor Number, Professor Full Name, Hire
Date and Job Description of those professors who are the part of
university faculty from last 6 months.
Hint: using aggregate functions like DATEADD (datepart, number,
date )
2. (Name View: Views_Two) Use Views_One as Nesting View
List columns name as Professor Full Name
1
, Project Name, Project
Assign Date and Assign Hours
Where Project Assign Date shouldn’t be older than 4 months and this
implies to those professors who are the part of university faculty from
last 6 months.
Hint:
Using (View named: Views_One) , PROFESSOR, ASSIGN AND PROJECT
relations here.
Notes:
1. Professor Full Name shall be from 1st Views named Views_Onee

sql help(rows to columns)

Fri, 19 Jun 2009 21:25:21 -0700

pl help

Table1 : Student(stu_id,studentname)

Table2 : Subjects(sub_id,subjectname)

Table3 : marks(marks_id,stu_id,sub_id,mark)

I need an sql query to display the output as follows:

name englsih maths science
qqwe 22 33 44
wqwe 55 11 33
rqwe 34 66 77

full outer join 2 views

Fri, 19 Jun 2009 04:57:06 -0700

My query is as follows..

select MAINSERVICENAME,wapCount,smsCount

from

((select
"MAINSERVICENAME","MAINSYSCODE" ,COUNT("MAINSYSCODE") AS wapCount
from "SMS_WAP"
where
(
"STATUS"=0
)
group by "MAINSYSCODE","MAINSERVICENAME")) WAPT

full outer join

((select
"MAINSERVICENAME","MAINSYSCODE" ,COUNT("MAINSYSCODE") AS smsCount
from "SMS_WAP"
where
(
"STATUS"=1
)
group by "MAINSYSCODE","MAINSERVICENAME") ) SMST

on (WAPT."MAINSYSCODE"=SMST."MAINSYSCODE");

But executing of this sql gives me an error "ORA-OO918 column ambiguously defined".Here "SMS_WAP" is a view . I want to know what is the fault in this query?

sqlbulkcopy issues

Thu, 18 Jun 2009 23:14:08 -0700

Dear All,

I have developed C# application to import data from CSV to SQL Server
using sqlBulkCopy. However I am facing couple of problems listed below

1. whole transfer fails when one record has column width issue (source column width is 30 and destination is 20) so how could I eliminate this row? or is there any work around?

2. my destination table has insert trigger defined. How could I manage to execute it as sqlbulkcopy dumps the whole bunch of records and not one by one record?

3. One column in destination table is computed column and is not included in the transfer, but the dependent column is included in source file (based on this column, computed column fills it data, while normal insert) but how do I fill values in computed column while dumping whole bunch of records?

4. If CDC(change data capture) is enabled on my target table, how SQLBulkCopy can log the data changes in the same?

regards
Jeet

"ANY (a, b) IN (expr)"

Wed, 17 Jun 2009 09:52:50 -0700

Hello

I recently dug up some old projects and noticed that in many of those I had queries that had "a IN (expr1) OR b IN (expr1)" as a condition. Some of the time, the expression was a list of values passed via parameters, some of the time it was a SELECT expression. Most of the time the expression had potential to become computationally expensive. In few places, there were also variants where there were more than 2 columns being matched against a list of candidates (eg: a IN (...) OR b IN (...) OR c IN (...))

Somewhere between those projects and today I have given up the practice of manual query building and have turned to ORM solutions instead. However, seeking to continue improving my knowledge and skills in the field, I keep on searching for optimal solutions for both past and present problems.

Discuss which languages have which ways of representing the aforementioned problem

Rows to column in sql server 2000

Mon, 15 Jun 2009 14:45:14 -0700

I am creating a report from a table that stores data as follows:
ID Name Activity Date Total
1 John Doe Play 2009-06-01 1
2 Jane Doe Run 2009-06-01 2

but i need to get the report in the format of

Name Play Run Total
John Doe 1 0 1
Jane Doe 0 2 2

i am unsure how to generate this result, any help would be great

Data Security for Oracle E-Business Suite

Wed, 10 Jun 2009 05:08:09 -0700

Change data source dynamically while updating web input report

Sat, 06 Jun 2009 03:41:38 -0700

Background
In web-based input report, users sometimes need to change data source dynamically. For example, in a web report, inputted data often need to be saved to different databases according to end users’ different options.
Then, how to achieve it with web reporting tool?

Solution
RAQ Report is a professional Web-based Java reporting tool, and it can help users to make report easily.
As a real Excel-like reporting tool, RAQ Report provides a wonderful solution to change data source dynamically while updating web report. With RAQ Report, users only need to call RAQ Report API. Then, data sources will be dynamically changed when it’s runing.
ReportDefine rd = (ReportDefine)ReportUtils.read(raq);
INormalCell cell = rd.getCell(2, (short)1);
InputProperty ip = cell.getInputProperty();
ArrayList al = ip.getUpdateList();
UpdateProperty up = (UpdateProperty)al.get(0);
// Get the corresponding relation
Object relations = up.getRelation();
if(relations instanceof com.runqian.report4.usermodel.input.TableRelations ){
TableRelations trs = (TableRelations)relations;
System.out.println(trs.getDataSourceName());
trs.setDataSourceName(”northwind”);
up.setRelation(trs);
ArrayList ups = new ArrayList(1);
ups.add(up);
ip.setUpdateList(ups);
cell.setInputProperty(ip);

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.

If you would like to read more articles about web reporting tool, you are also welcome to refer to my blog.

Need urgent help

Sat, 06 Jun 2009 00:41:26 -0700

Hi all,
I am having problem with username string matching ie Upper or lower case.It is accepting username in Small also and in caps alsO and Its accepting the space too !!! whenever i am providing the correct username and password.
I am giving u here the code ,pls reply with correct answer.

private void btnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("connection string");
string str;
str=("Select * from Logins where Username='"+txtUsername.Text+"' and Password='"+txtPassword.Text+"' ");
SqlCommand cmd = new SqlCommand(str,con);
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (((dt.Rows.Count > 0)&&(txtUsername.Text!=txtUsername.Text.ToLower()) )&&(txtPassword.Text!=txtPassword.Text.ToUpper()))
{
MessageBox.Show("WELCOME");
}
else
{

MessageBox.Show("INVALID USERNAME/password");
}
con.Close();
}

String matching from database

Sat, 06 Jun 2009 00:38:22 -0700

Hi all,
I am having problem with username string matching ie Upper or lower case.It is accepting username in Small also and in caps alsO ,whenever i am providing the correct username and password.
I am giving u here the code pls reply with correct answer.

private void btnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("connection string");
string str;
str=("Select * from Logins where Username='"+txtUsername.Text+"' and Password='"+txtPassword.Text+"' ");
SqlCommand cmd = new SqlCommand(str,con);
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (((dt.Rows.Count > 0)&&(txtUsername.Text!=txtUsername.Text.ToLower()) )&&(txtPassword.Text!=txtPassword.Text.ToUpper()))
{
MessageBox.Show("WELCOME");
}
else
{

MessageBox.Show("INVALID USERNAME/password");
}
con.Close();
}

Please explain a smiple question.

Tue, 02 Jun 2009 07:50:10 -0700

I've been into the C family of programming languages for some time now, although I've never been very good with it. I read that database programmers made good money and never have trouble getting a job, I don't know if that's true, but I did read that. I started to read a book on SQL but the book didn't even mention where or in what environment I needed to type my SQL commands in. It jumped straight in with commands like SELECT, I didn't even have a database to play with at this point. I just started reading a book on PHP & MySQL. Apart from having MySQL installed, I don't know anything about it or SQL. SQL is typed into the MySQL program, am I understanding that right. I'M just a little confused and I need some direction. I do love computers but I don't have a degree and I really want to quite working in a dead end no heat or AC factory. Can someone please steer me in the right direction please. Thanks.

sofswitch,billing,softphone,callback,calling card,more......

Mon, 01 Jun 2009 08:32:14 -0700

Dear Friends:

Want to setup VoIP company, a business under your own brand name? We have complete solution to launche VoIP (Voice Over Internet Protocol) company. All support comes included.
Features: PC2Phone, Device2Phone, Calling Card, Callback,sms callback solution, Ani Callback solution, DID callback solution, Cli Callback, Pin Callback, Wholesale Termination, Online Billing, Unlimited Resellers Creating, online shop, invoice generator, paypal integrated online shop, pin recharge modules, H323 and SIP.
No ties to us, deal with the wholesalers you want and buy VoIP minutes from any one in the market without any expensive equipment.

System

Single platform solution
Rapid Service Rollout
Pre-configured templates
Scalability - phased investment
Quick, flexible reporting
Open database architecture allowing for extended reporting functions and use of external scripts

Switching

Carrier-grade softswitch
Gatekeeper, registrar and proxy functionality
SIP and H323 protocol support
Protocols transparent conversion
Network protection capabilities
Advanced routing
Single entry point into VoIP infrastructure
Flexible proxy methods

Billing

Various authentication methods
Prepaid/postpaid accounts
Robust engine
Fully integration with the softswitch
Cooperation with MySQL or MSSQL

Management interface

Real-time traffic and system's performance monitor
Windows graphical interface
Web-based interface

Web interface for endusers

Customizable customer self care web interface
Admin section with embedded html editors
Ready to use design templates
CDRs, payments, invoices, address book, user's profile and others/
Sending SMS, web callback

IP IVR

Customizable IVR scenarios (XML)
Ready to use templates
Caller ID recognition
One or two stage calling procedures
Support for DIDs as access numbers

Softphone

Based on SIP protocol
Proprietary VOIP tunnel technology - making/receieving calls even behind voip blockades
Fully integration with the web interface
Quick access to voicemail
Sending SMS

Callback

Authentication by callerID or PIN
Various methods of realizing callback
Support for DIDs as callback service numbers
SMS and Web triggered callback
Embedded IVR system

Resellers system (VSR)

Multilevel structure
Web-based comprehensive interface
Support for multi-currency
Customizable web interface for end-users
Integration with the E-Shop

Callshop

Real-time monitoring and billing
Booths visualisation
Standalone and web based versions invoicing

E-Shop

Various payments processors
Credit cards, paypal, moneybookers
Automatic sign-up procedure
Recharge, also by vouchers/PINs
Basket for selling products online

SMS module

Support for http methods
Extended routing plan with support for multiple SMS providers
Integrated with the softphone and the end-users web interface
Support for wholesale SMS traffic

Capacity

Average result 1000 conncurent calls (full proxy) on one server (Dual Xeon CPU 2GB RAM*). For higher traffic recommended is cluster configuration with two or three servers with voipswitch software running on seperate servers and connected to one, shared SQL database installed on a dedicated server. Web services running on a backup SQL server set in replication mode so that the load from web requests (for example browsing CDRs, statistics) does not affect the performance of the main SQL server.

* tested and certified for SIP interoperatibility with Level3 (US based tier one carrier)

Scalability
Phased implementation of new services by enabling additional modules.

Operating system
Windows 2000, XP pro, Windows 2003 (both standard and web editions)

Hardware requirements
Recommended are servers based on Intel Xeon processors

dual core or quad core, in configuration of single or dual CPU,
RAM minimum 1GB,
HDD 100 GB or more

---------------------------------------------------------
Contact us if you are interested.

Thank you,
Apnavoip (.) net

Emails: sales(AT)apnavoip(DOT)net
apnavoip(AT)hotmail(DOT)com

(MSN/SALES): crm(AT)apnavoip(DOT)net
(msn/sUPPORT): support(AT)apnavoip(DOT)net
(YAHOO MESSENGER): apnavoip(AT)yahoo(DOT)com

Regards,
sales team www(DOT)apnavoip(DOT)net

THANKS