How to define custom parameter for map:serialize?

We have written a custom serializer and want to specify a custom parameter in the sitemap pipeline, not in serializer definition. This works but the parameter is fixed for the whole sitemap. But we want to define the parameter in the pipeline like: ...

RE: problems parsing xml from a foreign source in c2.0.0

> From: Donald Ball [mailto:[EMAIL PROTECTED]] > > On Fri, 8 Mar 2002, Jeff Turner wrote: > > > As a quick and dirty fix, you might want to try the SGML Open Catalog > > support that David Crossley added. That way you could map "-//NLM//DTD > > QueryResult, 22 Jan 2002//EN" to either the remote

RE: SearchGenerator Parameters

:) No need for patch, fix already found its way into CVS. Thanks, Vadim > From: Everton, Dan [mailto:[EMAIL PROTECTED]] > > Arrghhh! I swear I checked for that in SearchGenerator.java > > Obviously I wasn't looking hard enough. Anyway, fixing that > line makes everything work like it should n

Re: problems parsing xml from a foreign source in c2.0.0

On Fri, 8 Mar 2002, Jeff Turner wrote: > As a quick and dirty fix, you might want to try the SGML Open Catalog > support that David Crossley added. That way you could map "-//NLM//DTD > QueryResult, 22 Jan 2002//EN" to either the remote URL, or a local file > (faster). thanks for the tip. i'd al

Re: problems parsing xml from a foreign source in c2.0.0

Hi Donald, As a quick and dirty fix, you might want to try the SGML Open Catalog support that David Crossley added. That way you could map "-//NLM//DTD QueryResult, 22 Jan 2002//EN" to either the remote URL, or a local file (faster). --Jeff On Thu, Mar 07, 2002 at 12:29:43AM -0500, Donald Ball

Cocoon + UserAgent Strings

Hi all- I'm playing around with Cocoon, and I'm using http://foo.bar"/> to generate some XHTML from a website. I'm getting back a 403 Denied error from the server, and I've deduced that Cocoon is being denied access to the URL based on the User-Agent string that it sends. I did a little snoo

RE: SearchGenerator Parameters

Arrghhh! I swear I checked for that in SearchGenerator.java Obviously I wasn't looking hard enough. Anyway, fixing that line makes everything work like it should now. If someone wants a patch, I can generate one. Thanks, Dan > -- > Dan Everton > Engineering Infrastructure Coordinator > Centra

RE: SearchGenerator Parameters

Dan, Check this out, in SearchGenerator, line ~793: -- // get the directory where the index resides Directory directory = LuceneCocoonHelper.getDirectory(new File(workDir, "index"), false); lcs.setDirectory(directory); -- That's why it does not work :)))

C2.1: No valid JdbcConnection for MySQL

I managed to compile the 07-Mar-2002 HEAD cocoon source under WinXP/Java 1.4 and run it with Tomcat 4.0.3 LE - many thanks to Vadim Gritsenko. But got stuck with the following exception in core.log org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid JdbcConnection class av

SearchGenerator Parameters

Am I just thick or is there a particular reason that this entry in my sitemap doesn't do what I think it should? I would expect that would tell the SearchGenerator class to use the index in the working directory called "website-index" instead of the default "index". Instead I get

Re: Desperately need help: Running Java code with XML values as input

Ok, that is clear now. Tried a bunch of pipelines like this, to replicate the problem. Different results w/ different builds. Doesn't recompile w/ 2.0.1 and spits out some serverpages generator errors yesterday's 2.0.2-dev build. It's an interesting problem tho. Will post back if anythin

Re: xinclude problem

Sorry, hit send before pasting the link: RTFM at http://xml.apache.org/cocoon/userdocs/transformers/xinclude-transformer.html This takes an HREF. Might work w/ xsp:expr, never tried... On Thursday 07 March 2002 07:50 am, Stefano Bonnin wrote: > Hi I'm trying to use XInclude transf

Re: xinclude problem

RTFM: On Thursday 07 March 2002 07:50 am, you wrote: > Hi I'm trying to use XInclude transformer but when I run the Cocoon > application I receive the following error > > An error occurred > The org.apache.cocoon.www.sitemap_xmap notifies that > org.apache.cocoon.ProcessingException says: >

Re: Postgresql JDBC: NoAvailableConnectionException

On Thu, 7 Mar 2002 [EMAIL PROTECTED] wrote: > 1- I changed the datasource name (or pool name) to 'gesupply' (the name of > the database) from 'personnel'. Is this needed normally? you normally create a datasource with an appropriate name. the sample is named 'personnel' since it's for a fictiti

Re: Include XML file

On Thu, 7 Mar 2002, Stefano Bonnin wrote: > I'd like to include an XML document inside another. With C1 I used > util:include-file tag, but now, it (seems) doesn't work. > > How can I do this? you can use the xinclude or cinclude transformers, you can use the sitemap's aggregation features, or y

RE: Debugging Cocoon2 in JBuilder5

Title: RE: Debugging Cocoon2 in JBuilder5 Take a look at http://www.cocooncenter.de/cc/documents/resources/tips/c2int4injb5.html -Original Message- From: Todd Densmore [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 7 de Março de 2002 23:00 To: '[EMAIL PROTECTED]' Subject: Debuggi

Debugging Cocoon2 in JBuilder5

Has anyone had any luck getting Cocoon2 to run in JBuilder5 (with Tomcat4.0.1)? If so, I would be very interested to know how you did it, since I am trying to debug a cocoon2 app and would appreciate the debug features of the IDE rather than writing to the avalon logger and redeploying the war in

Re: Postgresql JDBC: NoAvailableConnectionException

Nevermind, it works now. 1- I changed the datasource name (or pool name) to 'gesupply' (the name of the database) from 'personnel'. Is this needed normally? 2- (and what, as a newbie, I think really fixed it) I started Tomcat from the "startup.bat" shortcut instead of starting it from the NT Se

Postgresql JDBC: NoAvailableConnectionException

Hey all, Ok, I'm new at this whole thing, and somewhat new at java as well, so please be patient with me Goal: to get a basic SELECT statement to work on a PostgreSQL database with the ESQL example. Known: 1- PGSQL server is on 192.168.100.3 2- Database is 'gesupply' 3- Sample ja

RE: Some Design Help, please

Thanks for the clue. I looked into my Cocoon/sitemap.xmap. Here's what I found for Bonebreaker AND MyApplication: With this, bonebreaker works but myapplication doesn't. I changed the mount src for MyApplication, so it l

RE: Correction: [SOLUTION] Cocoon with the Tomcat 4.0.3 (Linux)

> From: snpe [mailto:[EMAIL PROTECTED]] > > On Thursday 07 March 2002 07:37 pm, Vadim Gritsenko wrote: > > > From: snpe [mailto:[EMAIL PROTECTED]] > > > > > > > You need to get CVS version of Batik with some bug fixed. > > > > > > > > Vadim > > > > > > I do this and SVG work, menu in docs work, b

Re: writing xml to file

Not sure if you question was answered. I wrote a servlet that would get all of the nodes of the DOM representation of the XML document and create a list of name=value pairs for each node. Then I construct a form based upon this form. The user can then edit the text components of the attributes

RE: Some Design Help, please

Hi Sreedhar, >I am trying to fit bonebreaker into a new folder structure to learn some >site map fundas, and I am getting the following error: > org.apache.cocoon.ResourceNotFoundException: > No pipeline matched request: gvs//home/home.section That might be a problem with y

Re: Some Design Help, please

On Thu, Mar 07, 2002, Sreedhar Chintalapaty wrote: > The Bonebreaker application itself works perfectly. I wonder why it is > trying to find a match for "gvs//home/home.section" instead of > "gvs/home/home.section"? This is probably a frequently made newbie faux paus > with a stock answer, perhaps

RE: Some Design Help, please

I am trying to fit bonebreaker into a new folder structure to learn some site map fundas, and I am getting the following error: org.apache.cocoon.ResourceNotFoundException: No pipeline matched request: gvs//home/home.section The Bonebreaker application itself works perfect

Setting the SQL Prefetch...

Is there a way to set the SQL Prefetch value when using the Cocoon datasources? Example Java code would be: Statement sql = connection.createStatement(); sql.setFetchSize(100); ResultSet rs = sql.executeQuery("Select * from table"); I would imagine a parameter passed to

Re: Correction: [SOLUTION] Cocoon with the Tomcat 4.0.3 (Linux)

On Thursday 07 March 2002 07:37 pm, Vadim Gritsenko wrote: > > From: snpe [mailto:[EMAIL PROTECTED]] > > > > > You need to get CVS version of Batik with some bug fixed. > > > > > > Vadim > > > > I do this and SVG work, menu in docs work, but I haven't contents in > > doc > > Do you mean http://loc

Re: Cocoon 2.0.1 + Tomcat 4.0 + JDK 1.4

"Brian Blakeley" <[EMAIL PROTECTED]> writes: > At first I was going to just say upgrade your IE - but it does not display > in 6.002 either. > > The good news is that the site loads fine in Netscape 6.2 which in a > perverse arrangement I use for view links from Outlook. > > Give it a try if yo

RE: Correction: [SOLUTION] Cocoon with the Tomcat 4.0.3 (Linux)

> From: snpe [mailto:[EMAIL PROTECTED]] > > > You need to get CVS version of Batik with some bug fixed. > > > > Vadim > > I do this and SVG work, menu in docs work, but I haven't contents in doc Do you mean http://localhost:8080/cocoon/documentation/ shows navigation but does not have content?

Re: Correction: [SOLUTION] Cocoon with the Tomcat 4.0.3 (Linux)

> You need to get CVS version of Batik with some bug fixed. > > Vadim I do this and SVG work, menu in docs work, but I haven't contents in doc regards peco - Please check that your question has not already been answered in the

Re: Cocoon 2.0.1 and Sun JDK 1.4

From: Lars Schmitz > is Cocoon 2.0.1 running with Sun's JDK 1.4? Yes -- Nicola Ken Barozzi [EMAIL PROTECTED] - verba volant, scripta manent - (discussions get forgotten, just code remains) -

Cocoon 2.0.1 and Sun JDK 1.4

Hi folks,   is Cocoon 2.0.1 running with Sun's JDK 1.4? Thanks in advance       Lars

Re: Separating icons' file name from main XSL

On Wed, Mar 06, 2002 at 04:21:23PM +0100, TREGAN Fabien wrote: > Hi, > > I'm making my first Cocoon application. > Like many others, all it does is open an XML file and create a table from it > using an XSL file. > > I'd like to have the definition of each icon's file to be outside of the XSL >

RE: HOWTO: jdk1.4

I think this is the same issue as with parser: Batik has some classes in org.w3c.* hierarchy, it needs to override or add some classes there. To do this in JDK1.4, you copy it into endorsed dir (or as you did - into ext dir) Vadim > From: Bhide, Atul [mailto:[EMAIL PROTECTED]] > > Thanks Vadim,

RE: HOWTO: jdk1.4

Thanks Vadim, You are right. I did not quite get it in your last email. One more thing though why do I have to copy xml-apis and batik to JRE/LIB/EXT dir to make Cocoon work. I probed around the Cocoon and Tomcat log but could not get the real reason why both these jar files are not picked up fr

Re: Desperately need help: Running Java code with XML values as input

Check my other post for a better description of what I need... And yeah, I did mean test=write... On Thursday, March 7, 2002, at 02:45 AM, KOZLOV Roman wrote: > Hello Noah, > > Excuse me, please, if I'm too pedantic, but did you mean > "test=write" instead of > "write=test"? > > Best regards >

xinclude problem

Hi I'm trying to use XInclude transformer but when I run the Cocoon application I receive the following error An error occurred The org.apache.cocoon.www.sitemap_xmap notifies that org.apache.cocoon.ProcessingException says: Failed to execute pipeline. More precisely: org.apache.cocoon.Process

Re: upload dir [outside cocoon]

is it possible to upload something into a directory outside cocoons installation? for example into /tmp ore /home thank kounis stavros On Thu, 7 Mar 2002, Olivier Rossel wrote: > Cocoon User wrote: > > >i'm using cocoon 2.0.rc2 > >with tomcat and apache > > > >how can i change the upload fo

Can't see pages

Hi peeploe, I have installed cocoon and now still have a problem. When I point with the broswer to myhost/cocoon I have a list of files but. When I click over a file i see and XML file whit a lot of tags.. what can i do to see a page compiled? At server.xml (tomcat) i made an entry for cocoon. is

RE: CInclude Question

Thanks Roman, it was exactly what I was doing wrong. (as you can see, I am new to XSL too) Sreedhar -Original Message- From: KOZLOV Roman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:34 AM To: Cocoon users mail list Subject: Re: CInclude Question Hello Sreedhar, Your p

Re: upload dir

Cocoon User wrote: >i'm using cocoon 2.0.rc2 >with tomcat and apache > >how can i change the upload for the upload.xsp? > > >thanks >kounis stavros >osmosis.gr > the upload dir is defined in your WEB-INF/web.xml The upload dir is unique to your cocoon instance.

upload dir

i'm using cocoon 2.0.rc2 with tomcat and apache how can i change the upload for the upload.xsp? thanks kounis stavros osmosis.gr - Please check that your question has not already been answered in the FAQ before posting.

RE: Correction: [SOLUTION] Cocoon with the Tomcat 4.0.3 (Linux)

> From: snpe [mailto:[EMAIL PROTECTED]] > > On Wednesday 06 March 2002 06:26 pm, Vadim Gritsenko wrote: > > > From: snpe [mailto:[EMAIL PROTECTED]] > > > > > > Hello, > > > I try your solution on Linux. > > > I get tomcat-4.0.3 from source, compile and execute with JDK1.4 > > > > Ok, my fault.

RE: Problem with XSP and assigning

On Thu, 7 Mar 2002, Vadim Gritsenko wrote: > > > xmlns:xsp="http://apache.org/xsp"; > > xmlns:xsp-request="http://apache.org/xsp/request/2.0";> > > > > > > String uri = null; > > uri = ; > > > > > > What are the symptoms? Hi Vadim, It's fixed now, thanks (actually thanks t

Re: Correction: [SOLUTION] Cocoon with the Tomcat 4.0.3 (Linux)

On Wednesday 06 March 2002 06:26 pm, Vadim Gritsenko wrote: > > From: snpe [mailto:[EMAIL PROTECTED]] > > > > Hello, > > I try your solution on Linux. > > I get tomcat-4.0.3 from source, compile and execute with JDK1.4 > > Ok, my fault. One more correction: these steps are for JDK1.3.1. Searc

(re)acting on XML-Data

Hello! For user-authentication I use the XMLDBSourceFactory with a query for username/password. The result looks something like this: http://apache.org/cocoon/xmldb/1.0";> http://xml.apache.org/xindice/Query"; src:col="/db/xy/xy" src:key="xy"> X Y

RE: Some Design Help, please

Thanks. I have learnt much from this link. Best Regards, Sreedhar -Original Message- From: Andrew John Savory [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew Savory Sent: Wednesday, March 06, 2002 4:16 AM To: Sreedhar Chintalapaty Cc: Cocoon Users Subject: Re: Some Design Help, please

RE: Problem with install Cocoon 2.0.1 on w2k :(

> From: bartek [mailto:[EMAIL PROTECTED]] > > Hi, > > I have : > win2k professional, > tomcat 4.0.3, Use 4.0.1 or search archives for instructions. Vadim > cocoon 2.0.1, > jdk 1.3.1, > I copy file xerces.jar to tomcat\lib\parser.jar > I copy cocoon.war to tomcat\webapps\

AW: Include XML file

-Ursprüngliche Nachricht- Von: Stefano Bonnin [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 07. März 2002 14:07 An: [EMAIL PROTECTED] Betreff: Include XML file Hi, I'd like to include an XML document inside another. With C1 I used util:include-file tag, but now, it (seems) doesn't

RE: Problem with XSP and assigning

> From: Andrew John Savory [mailto:[EMAIL PROTECTED]] On Behalf Of Andrew > Savory > Sent: Thursday, March 07, 2002 6:10 AM > To: [EMAIL PROTECTED] > Subject: Problem with XSP and assigning > > > Hi, > > Can someone spot my deliberate mistake here? It's driving me up the wall > trying to find

Livesite

Hello World. A new Cocoon2-Application is online: http://www.lofex.de We would like to ask you for public listing of this URL on 'xml.apache.org'. LOFEX is an acronym for 'LOcal Food EXpress'. It's an Cocoon 2.0RC1 based food shopping mall system and provides different views for e.g. customers

Include XML file

Hi, I'd like to include an XML document inside another. With C1 I used util:include-file tag, but now, it (seems) doesn't work. How can I do this? Which is the better way? Thanks to all. --- Outgoing mail is certified Virus Free. (CopyRight FLASHH!) Checked by AVG anti-virus system (http:/

Problem with install Cocoon 2.0.1 on w2k :(

Hi, I have : win2k professional, tomcat 4.0.3, cocoon 2.0.1, jdk 1.3.1, I copy file xerces.jar to tomcat\lib\parser.jar I copy cocoon.war to tomcat\webapps\cocoon.war and after install when I try browse http://localhost:8080/cocoon such error : Apache Tomcat/4.0.3 - HTTP Status 500 - Int

RE: PERSONAL JAVA CLASSES

Stefano, I put my JARs into $tomcat_home\webapps\cocoon\WEB-INF\lib... and it works :) Best regards, - Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html --

Re: PERSONAL JAVA CLASSES

Istvan Beszteri wrote: >.../cocoon/WEB-INF/classes/ >works for me, >but you can check the WEB-INF/web.xml, how to define extra calsspaths. >Br, > Istvan > >On Thursday 07 March 2002 13:41, you wrote: > >>Hi, >> >>Where must I put "my personal Java classes" in Cocoon 2? (which directory?) >>

Re: PERSONAL JAVA CLASSES

.../cocoon/WEB-INF/classes/ works for me, but you can check the WEB-INF/web.xml, how to define extra calsspaths. Br, Istvan On Thursday 07 March 2002 13:41, you wrote: > Hi, > > Where must I put "my personal Java classes" in Cocoon 2? (which directory?) > > Thanks > > > --- > Outgoing mai

PERSONAL JAVA CLASSES

Hi, Where must I put "my personal Java classes" in Cocoon 2? (which directory?) Thanks --- Outgoing mail is certified Virus Free. (CopyRight FLASHH!) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 28/02/02 ---

Re: Problem with XSP and assigning

Andrew Savory wrote: >Hi, > >Can someone spot my deliberate mistake here? It's driving me up the wall >trying to find out why Cocoon doesn't like the following: > > xmlns:xsp="http://apache.org/xsp"; > xmlns:xsp-request="http://apache.org/xsp/request/2.0";> > > >String uri = null; >ur

Problem with XSP and assigning

Hi, Can someone spot my deliberate mistake here? It's driving me up the wall trying to find out why Cocoon doesn't like the following: http://apache.org/xsp"; xmlns:xsp-request="http://apache.org/xsp/request/2.0";> String uri = null; uri = ; Help! Andrew. -- Andrew Savory

Re: Another problem with Sitemap

Ok I find the error I used http://www.apache.org/1999/XSP/Core instead of http://apache.org/xsp - Original Message - From: "Stefano Bonnin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 07, 2002 10:27 AM Subject: Re: Another problem with Sitemap > > - Origina

RE: AW: Problems with font embedding

On Thu, 7 Mar 2002, Matthias Fischer wrote: > I've got a diofferent opinion. I've done technical docu for several years: > the criterion of measurement of a docu is its user! For sure... but then you also should know that docu for software that is still (fast) progressing *cannot* be up-to-date.

RE: Problems with font embedding

I'm sorry, I wrote the docs originally as some notes on how I got it to work. I went through them yesterday and, apart from jar names and path changes the steps remain unchanged. I *know* that the folks who should have the last word are users, but no-bodies bothered to say "this is wrong it shou

RE: Problems with font embedding

:-))) -Original Message- From: Torsten Curdt [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:49 AM To: [EMAIL PROTECTED] Subject: RE: Problems with font embedding On Thu, 7 Mar 2002, Matthias Fischer wrote: > Was this your last word, John? > > I can assure you, it's three

RE: AW: Problems with font embedding

I've got a diofferent opinion. I've done technical docu for several years: the criterion of measurement of a docu is its user! Thus, if I assure you that we read the stuff through and through, there are only two alternative interpretations: either that we are as dumb as hell, and that we'd better

RE: Problems with font embedding

On Thu, 7 Mar 2002, Matthias Fischer wrote: > Was this your last word, John? > > I can assure you, it's three of us who try to get a solution for the last > six months (of course, we did other things in the same space of time, too > ;-). We damned read the documentation, and not only once. We got

Re: AW: Problems with font embedding

On Thu, 7 Mar 2002, Adnan Zelkanovic wrote: > of course, I have read it many times. > Why do you want me to read the docu again although you know that its > "out-of-date" ? > If the developers don't want to be asked the same questions again and again > then they > have to write a better docu whic

RE: Problems with font embedding

Was this your last word, John? I can assure you, it's three of us who try to get a solution for the last six months (of course, we did other things in the same space of time, too ;-). We damned read the documentation, and not only once. We got onto people's nerves in the lists to get a solution,

Re: my svg does not work in cocoon 2.0.1

On Thu, 7 Mar 2002, marco wrote: > ERROR IN CORE.LOG:*** > DEBUG (2002-03-07) 14:03.01:930 [core] > (/cocoon/f_portal/f_portal_svg/2b4986-ec6f1495e0--7ff7.png) > HttpProcessor[8080][4]/ExcaliburComponentSelector: UnnamedSelector: > ComponentSelector could not find

Re: Another problem with Sitemap

- Original Message - From: "Vadim Gritsenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 3:34 PM Subject: RE: Another problem with Sitemap > > From: Stefano Bonnin [mailto:[EMAIL PROTECTED]] > > > > Hi, thanks to all for the previous help about my issues

AW: Problems with font embedding

of course, I have read it many times. Why do you want me to read the docu again although you know that its "out-of-date" ? If the developers don't want to be asked the same questions again and again then they have to write a better docu which is "up-to-date" and which can be understood by everyone

RE: howto get rid of long url without Apache web server?

Marco, to get rid of ":8080" you shuold redirect all request containing, for instance, "*.html", to port 8080. This could be done in the web-server, which handles all default (port 80) requests. In IIS you could use the tomcat ISAPI filter (see Tomcat docs for more), in Apache you could use mod_r

RE: howto get rid of long url without Apache web server?

mmm... this definitively is a TOMCAT user question, not a Cocoon user question... so I wont answer here, sorry. (btw you should find in server.xml and replace 8080 by 80 : 80 being default HTTP port, you wont have to hade it. You may rename cocoon.war in ROOT.war after you have deleted the ROOT

Re: howto validate user input field via database data?

On 07.Mar.2002 -- 03:35 PM, marco wrote: > I have a program to let user add records to a table of "country" and the > user has to input a new code for a new country. I have to check the > existenance of the new user input code in the database table, before saving > inserting the new record. > > W

Re: howto get rid of long url without Apache web server?

marco wrote: >I have installed Tomcat 4.0.1, cocoon 2.0.0, jdk1.3.1_01 (no Apache web >server) in Windows 98. > >How can I access my web site by url "http://www.mysite.com/index.html"; >instead of "http://www.mysite.com:8080/cocoon/myproject/index.html"; ? > >-

RE: howto get rid of long url without Apache web server?

Tomcat requires the 8080; look in it's doc's on how to change it. /cocoon is the webapp change it to be root (again, tc question). myproject is sitemap - don't match it :) J. > -Original Message- > From: marco [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 07 March 2002 8:48 am > To: [EMAI

howto get rid of long url without Apache web server?

I have installed Tomcat 4.0.1, cocoon 2.0.0, jdk1.3.1_01 (no Apache web server) in Windows 98. How can I access my web site by url "http://www.mysite.com/index.html"; instead of "http://www.mysite.com:8080/cocoon/myproject/index.html"; ? --

Re: howto validate user input field via database data?

I think you need to supply a little more detail here; do you have two tables (it sounds like it might be necessary) - in which case, the adding of codes is a separate operation. Derek >>> [EMAIL PROTECTED] 07/03/2002 09:35:57 >>> I have a program to let user add records to a table of "country" a

howto validate user input field via database data?

I have a program to let user add records to a table of "country" and the user has to input a new code for a new country. I have to check the existenance of the new user input code in the database table, before saving inserting the new record. What can I do? --