Showing posts with label contains. Show all posts
Showing posts with label contains. Show all posts

Thursday, March 29, 2012

Pass information from XML file to ASPX page

Hello,
I have an XML file, which contains let's say a <A> tag with a "AProp"
property. I want to manipulate this XML file so that the value of the
AProp property can be passed to the code-behind class (let's say
code.aspx.cs) of another ASPX page. How can I accomplish that?
Thanks in advance for help,
uservoidHi evangelous,
Maybe this can help you:
http://www.planet-source-code.com/v...gWId=10

Guillermo G.
----
--
Guillermo Gonzlez Arroyave :: MCP ASP.Net C# :: DCE4
<evangelous@.gmail.com> wrote in message news:1122017876.519551.161420@.g49g20
00cwa.googlegroups.com...
Hello,
I have an XML file, which contains let's say a <A> tag with a "AProp"
property. I want to manipulate this XML file so that the value of the
AProp property can be passed to the code-behind class (let's say
code.aspx.cs) of another ASPX page. How can I accomplish that?
Thanks in advance for help,
uservoid

Pass information from XML file to ASPX page

Hello,

I have an XML file, which contains let's say a <A> tag with a "AProp"
property. I want to manipulate this XML file so that the value of the
AProp property can be passed to the code-behind class (let's say
code.aspx.cs) of another ASPX page. How can I accomplish that?

Thanks in advance for help,
uservoidHi evangelous,

Maybe this can help you:
http://www.planet-source-code.com/v...=3753&lngWId=10

Guillermo G.

------------------------
Guillermo Gonzlez Arroyave :: MCP ASP.Net C# :: DCE4

<evangelous@.gmail.com> wrote in message news:1122017876.519551.161420@.g49g2000cwa.googlegr oups.com...
Hello,

I have an XML file, which contains let's say a <A> tag with a "AProp"
property. I want to manipulate this XML file so that the value of the
AProp property can be passed to the code-behind class (let's say
code.aspx.cs) of another ASPX page. How can I accomplish that?

Thanks in advance for help,
uservoid

Monday, March 26, 2012

pass the arguments from web to windows

Hi all,
I have created one web applicatication which contains button.When I
click the button
I want to pass arguments to windows application.Can I do it?Any one
please help me...
Regards justinHi,
How about this code:

string strArg = @." the arguments comes here";

process.StartInfo.Arguments = strArg;

process.StartInfo.UseShellExecute = false;

process.StartInfo.RedirectStandardOutput = true;

try

{

process.Start();

}

catch(Exception ex)

{

string str = ex.Source + ex.Message + ex.StackTrace;

}

Thanks and Regards,
Manish Bafna.
MCP and MCTS.

"justin" wrote:

Quote:

Originally Posted by

Hi all,
I have created one web applicatication which contains button.When I
click the button
I want to pass arguments to windows application.Can I do it?Any one
please help me...
Regards justin
>
>


The simplest (or one of the simplest) way of communicating between
applications is via text files. One guy writes, another reads.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

"justin" <justindhasy@.gmail.comwrote in message
news:1166424002.419061.231640@.j72g2000cwa.googlegr oups.com...

Quote:

Originally Posted by

Hi all,
I have created one web applicatication which contains button.When I
click the button
I want to pass arguments to windows application.Can I do it?Any one
please help me...
Regards justin
>

pass the arguments from web to windows

Hi all,
I have created one web applicatication which contains button.When I
click the button
I want to pass arguments to windows application.Can I do it?Any one
please help me...
Regards justinHi,
How about this code:
string strArg = @." the arguments comes here";
process.StartInfo.Arguments = strArg;
process.StartInfo.UseShellExecute = false;
process.StartInfo.RedirectStandardOutput = true;
try
{
process.Start();
}
catch(Exception ex)
{
string str = ex.Source + ex.Message + ex.StackTrace;
}
Thanks and Regards,
Manish Bafna.
MCP and MCTS.
"justin" wrote:

> Hi all,
> I have created one web applicatication which contains button.When I
> click the button
> I want to pass arguments to windows application.Can I do it?Any one
> please help me...
> Regards justin
>
The simplest (or one of the simplest) way of communicating between
applications is via text files. One guy writes, another reads.
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"justin" <justindhasy@.gmail.com> wrote in message
news:1166424002.419061.231640@.j72g2000cwa.googlegroups.com...
> Hi all,
> I have created one web applicatication which contains button.When I
> click the button
> I want to pass arguments to windows application.Can I do it?Any one
> please help me...
> Regards justin
>

Pass value from javascript to vb.net to database without postback...Possible?

Hi,
I have a complicated question that I'm hoping someone can help me out
with. I have a webpage that contains a plug-in. This plug-in can
communicate/pass data with the webpage that contains it via javascript.
What I need to be able to do is take that data passed via javascript
and, using vb.net as the code behind language, send it to a database
without posting it because when I post, the plugin is reloaded and
starts at the beginning. Specifcally, the plug-in is a type of
educational program, when the user completes a certain objective in the
program, I need to store that info in the database but not have the
program start back at the beginning.
What happens currently is upon completing the objective in the plugin,
a javascript function is called in the containing webpage. That
javascript function changes the data in a hidden field runat the
server. I artificially create a postback using the
document.forms.submit() function, then in the page_load function in the
codebehind page I check the value of the hidden field and store it to
the database. This works fine. The problem is that when the page
reloads, my plug-in is reloaded and instead of the user being at say
level 6, they are back at the initial level 1. Ideally, I would like to
send the information to the database without having to reload the page
and was wondering if this was possible.
Thanks in advance and I'll be happy to clarify any questions.
AndyYou would need to do something like use XMLHTTP to issue a call to a page to
do the work. However, I think that ties you to IE 5.5 and above. This may
or may not be a problem for you.
"Andy" <acs974@.hotmail.com> wrote in message
news:1129749048.607189.307420@.g44g2000cwa.googlegroups.com...
> Hi,
> I have a complicated question that I'm hoping someone can help me out
> with. I have a webpage that contains a plug-in. This plug-in can
> communicate/pass data with the webpage that contains it via javascript.
> What I need to be able to do is take that data passed via javascript
> and, using vb.net as the code behind language, send it to a database
> without posting it because when I post, the plugin is reloaded and
> starts at the beginning. Specifcally, the plug-in is a type of
> educational program, when the user completes a certain objective in the
> program, I need to store that info in the database but not have the
> program start back at the beginning.
> What happens currently is upon completing the objective in the plugin,
> a javascript function is called in the containing webpage. That
> javascript function changes the data in a hidden field runat the
> server. I artificially create a postback using the
> document.forms.submit() function, then in the page_load function in the
> codebehind page I check the value of the hidden field and store it to
> the database. This works fine. The problem is that when the page
> reloads, my plug-in is reloaded and instead of the user being at say
> level 6, they are back at the initial level 1. Ideally, I would like to
> send the information to the database without having to reload the page
> and was wondering if this was possible.
> Thanks in advance and I'll be happy to clarify any questions.
> Andy
>
the easiest approach is a hidden iframe/frame.
1) the src of the hidden frame should be an aspx page with hidden fields.
the clientscript would fill in the hidden fields in the frame, and do a
submit of the frame.
2) create an addtional form (nonserver) on the page with the target the
hidden frame, have the client script fill in the hidden fields in the form
and do a submit.
-- bruce (sqlwork.com)
"Andy" <acs974@.hotmail.com> wrote in message
news:1129749048.607189.307420@.g44g2000cwa.googlegroups.com...
> Hi,
> I have a complicated question that I'm hoping someone can help me out
> with. I have a webpage that contains a plug-in. This plug-in can
> communicate/pass data with the webpage that contains it via javascript.
> What I need to be able to do is take that data passed via javascript
> and, using vb.net as the code behind language, send it to a database
> without posting it because when I post, the plugin is reloaded and
> starts at the beginning. Specifcally, the plug-in is a type of
> educational program, when the user completes a certain objective in the
> program, I need to store that info in the database but not have the
> program start back at the beginning.
> What happens currently is upon completing the objective in the plugin,
> a javascript function is called in the containing webpage. That
> javascript function changes the data in a hidden field runat the
> server. I artificially create a postback using the
> document.forms.submit() function, then in the page_load function in the
> codebehind page I check the value of the hidden field and store it to
> the database. This works fine. The problem is that when the page
> reloads, my plug-in is reloaded and instead of the user being at say
> level 6, they are back at the initial level 1. Ideally, I would like to
> send the information to the database without having to reload the page
> and was wondering if this was possible.
> Thanks in advance and I'll be happy to clarify any questions.
> Andy
>
Once you're upgraded to ASP.NET 2.0 you can use the new client side
callback feature to do this kind of thing.
Here's more info:
http://www.aspnetpro.com/features/2...p200511so_f.asp
http://www.developer.com/net/asp/article.php/3506896
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Andy" <acs974@.hotmail.com> wrote in message
news:1129749048.607189.307420@.g44g2000cwa.googlegroups.com...
> Hi,
> I have a complicated question that I'm hoping someone can help me out
> with. I have a webpage that contains a plug-in. This plug-in can
> communicate/pass data with the webpage that contains it via javascript.
> What I need to be able to do is take that data passed via javascript
> and, using vb.net as the code behind language, send it to a database
> without posting it because when I post, the plugin is reloaded and
> starts at the beginning. Specifcally, the plug-in is a type of
> educational program, when the user completes a certain objective in the
> program, I need to store that info in the database but not have the
> program start back at the beginning.
> What happens currently is upon completing the objective in the plugin,
> a javascript function is called in the containing webpage. That
> javascript function changes the data in a hidden field runat the
> server. I artificially create a postback using the
> document.forms.submit() function, then in the page_load function in the
> codebehind page I check the value of the hidden field and store it to
> the database. This works fine. The problem is that when the page
> reloads, my plug-in is reloaded and instead of the user being at say
> level 6, they are back at the initial level 1. Ideally, I would like to
> send the information to the database without having to reload the page
> and was wondering if this was possible.
> Thanks in advance and I'll be happy to clarify any questions.
> Andy
>
if you don't need anything back, it's trivial:
var sender = new Image();
sender.src = "whatever.aspx?stufff=1&junkID=27";
Done, and done.
Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/
Get your own Travel Blog, with itinerary maps and photos!
http://www.blogabond.com/
Thanks everyone for their help. It seems that ajax is probably going to
be the way I go. I tried to avoid it since I'm pretty new to this web
programming and didn't understand if it was for me, but it seems that's
what I need long term. One quick question, I've been using asp.net 2.0
but because it is in its beta form, I have avoided exploiting much of
its newer features. How worried do I have to be about creating a
website in 2.0 beta then having it not work on me when the final
release comes out?

Pass value from javascript to vb.net to database without postback...Possible?

Hi,

I have a complicated question that I'm hoping someone can help me out
with. I have a webpage that contains a plug-in. This plug-in can
communicate/pass data with the webpage that contains it via javascript.
What I need to be able to do is take that data passed via javascript
and, using vb.net as the code behind language, send it to a database
without posting it because when I post, the plugin is reloaded and
starts at the beginning. Specifcally, the plug-in is a type of
educational program, when the user completes a certain objective in the
program, I need to store that info in the database but not have the
program start back at the beginning.

What happens currently is upon completing the objective in the plugin,
a javascript function is called in the containing webpage. That
javascript function changes the data in a hidden field runat the
server. I artificially create a postback using the
document.forms.submit() function, then in the page_load function in the
codebehind page I check the value of the hidden field and store it to
the database. This works fine. The problem is that when the page
reloads, my plug-in is reloaded and instead of the user being at say
level 6, they are back at the initial level 1. Ideally, I would like to
send the information to the database without having to reload the page
and was wondering if this was possible.

Thanks in advance and I'll be happy to clarify any questions.

AndyYou would need to do something like use XMLHTTP to issue a call to a page to
do the work. However, I think that ties you to IE 5.5 and above. This may
or may not be a problem for you.

"Andy" <acs974@.hotmail.com> wrote in message
news:1129749048.607189.307420@.g44g2000cwa.googlegr oups.com...
> Hi,
> I have a complicated question that I'm hoping someone can help me out
> with. I have a webpage that contains a plug-in. This plug-in can
> communicate/pass data with the webpage that contains it via javascript.
> What I need to be able to do is take that data passed via javascript
> and, using vb.net as the code behind language, send it to a database
> without posting it because when I post, the plugin is reloaded and
> starts at the beginning. Specifcally, the plug-in is a type of
> educational program, when the user completes a certain objective in the
> program, I need to store that info in the database but not have the
> program start back at the beginning.
> What happens currently is upon completing the objective in the plugin,
> a javascript function is called in the containing webpage. That
> javascript function changes the data in a hidden field runat the
> server. I artificially create a postback using the
> document.forms.submit() function, then in the page_load function in the
> codebehind page I check the value of the hidden field and store it to
> the database. This works fine. The problem is that when the page
> reloads, my plug-in is reloaded and instead of the user being at say
> level 6, they are back at the initial level 1. Ideally, I would like to
> send the information to the database without having to reload the page
> and was wondering if this was possible.
> Thanks in advance and I'll be happy to clarify any questions.
> Andy
Look at AJAX.net
It may take care of your needs in this case.

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

"Andy" wrote:

> Hi,
> I have a complicated question that I'm hoping someone can help me out
> with. I have a webpage that contains a plug-in. This plug-in can
> communicate/pass data with the webpage that contains it via javascript.
> What I need to be able to do is take that data passed via javascript
> and, using vb.net as the code behind language, send it to a database
> without posting it because when I post, the plugin is reloaded and
> starts at the beginning. Specifcally, the plug-in is a type of
> educational program, when the user completes a certain objective in the
> program, I need to store that info in the database but not have the
> program start back at the beginning.
> What happens currently is upon completing the objective in the plugin,
> a javascript function is called in the containing webpage. That
> javascript function changes the data in a hidden field runat the
> server. I artificially create a postback using the
> document.forms.submit() function, then in the page_load function in the
> codebehind page I check the value of the hidden field and store it to
> the database. This works fine. The problem is that when the page
> reloads, my plug-in is reloaded and instead of the user being at say
> level 6, they are back at the initial level 1. Ideally, I would like to
> send the information to the database without having to reload the page
> and was wondering if this was possible.
> Thanks in advance and I'll be happy to clarify any questions.
> Andy
>
the easiest approach is a hidden iframe/frame.

1) the src of the hidden frame should be an aspx page with hidden fields.
the clientscript would fill in the hidden fields in the frame, and do a
submit of the frame.

2) create an addtional form (nonserver) on the page with the target the
hidden frame, have the client script fill in the hidden fields in the form
and do a submit.

-- bruce (sqlwork.com)

"Andy" <acs974@.hotmail.com> wrote in message
news:1129749048.607189.307420@.g44g2000cwa.googlegr oups.com...
> Hi,
> I have a complicated question that I'm hoping someone can help me out
> with. I have a webpage that contains a plug-in. This plug-in can
> communicate/pass data with the webpage that contains it via javascript.
> What I need to be able to do is take that data passed via javascript
> and, using vb.net as the code behind language, send it to a database
> without posting it because when I post, the plugin is reloaded and
> starts at the beginning. Specifcally, the plug-in is a type of
> educational program, when the user completes a certain objective in the
> program, I need to store that info in the database but not have the
> program start back at the beginning.
> What happens currently is upon completing the objective in the plugin,
> a javascript function is called in the containing webpage. That
> javascript function changes the data in a hidden field runat the
> server. I artificially create a postback using the
> document.forms.submit() function, then in the page_load function in the
> codebehind page I check the value of the hidden field and store it to
> the database. This works fine. The problem is that when the page
> reloads, my plug-in is reloaded and instead of the user being at say
> level 6, they are back at the initial level 1. Ideally, I would like to
> send the information to the database without having to reload the page
> and was wondering if this was possible.
> Thanks in advance and I'll be happy to clarify any questions.
> Andy
Once you're upgraded to ASP.NET 2.0 you can use the cool new client side
callback feature to do this kind of thing.

Here's more info:
http://www.aspnetpro.com/features/2...p200511so_f.asp
http://www.developer.com/net/asp/article.php/3506896

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"Andy" <acs974@.hotmail.com> wrote in message
news:1129749048.607189.307420@.g44g2000cwa.googlegr oups.com...
> Hi,
> I have a complicated question that I'm hoping someone can help me out
> with. I have a webpage that contains a plug-in. This plug-in can
> communicate/pass data with the webpage that contains it via javascript.
> What I need to be able to do is take that data passed via javascript
> and, using vb.net as the code behind language, send it to a database
> without posting it because when I post, the plugin is reloaded and
> starts at the beginning. Specifcally, the plug-in is a type of
> educational program, when the user completes a certain objective in the
> program, I need to store that info in the database but not have the
> program start back at the beginning.
> What happens currently is upon completing the objective in the plugin,
> a javascript function is called in the containing webpage. That
> javascript function changes the data in a hidden field runat the
> server. I artificially create a postback using the
> document.forms.submit() function, then in the page_load function in the
> codebehind page I check the value of the hidden field and store it to
> the database. This works fine. The problem is that when the page
> reloads, my plug-in is reloaded and instead of the user being at say
> level 6, they are back at the initial level 1. Ideally, I would like to
> send the information to the database without having to reload the page
> and was wondering if this was possible.
> Thanks in advance and I'll be happy to clarify any questions.
> Andy
if you don't need anything back, it's trivial:

var sender = new Image();
sender.src = "whatever.aspx?stufff=1&junkID=27";

Done, and done.

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/

--
Get your own Travel Blog, with itinerary maps and photos!
http://www.blogabond.com/
Thanks everyone for their help. It seems that ajax is probably going to
be the way I go. I tried to avoid it since I'm pretty new to this web
programming and didn't understand if it was for me, but it seems that's
what I need long term. One quick question, I've been using asp.net 2.0
but because it is in its beta form, I have avoided exploiting much of
its newer features. How worried do I have to be about creating a
website in 2.0 beta then having it not work on me when the final
release comes out?
Be very worried! Well, not to scare you or anything but seriously, any new
product in beta is not going to be 100% reliable. That's why they call it
alpha, beta.
That being said, you can do a search on google for a list of issues in beta,
that way you can be aware of what's going to work on final release.

"Andy" wrote:

> Thanks everyone for their help. It seems that ajax is probably going to
> be the way I go. I tried to avoid it since I'm pretty new to this web
> programming and didn't understand if it was for me, but it seems that's
> what I need long term. One quick question, I've been using asp.net 2.0
> but because it is in its beta form, I have avoided exploiting much of
> its newer features. How worried do I have to be about creating a
> website in 2.0 beta then having it not work on me when the final
> release comes out?
>

Wednesday, March 21, 2012

Passing a CSV file into APSX page and returning query from SQL server using CSV data?

Is this possible basically?

I have a CSV file that contains a list of barcodes, I would like to create a page that will upload this into a temp table of some kind and query a SQL using the CSV file to join the data to the table.

This would then output the result to a list on the page.


Any ideas? As yet I haven't managed to start anything on ASP.net yet!

Of course it's possible. Almost anything is possible. When you get to your coding you should ask the specific questions that you need answered.


Here is one way on how to do this

1. Read your file using FileStream.
2. Create a datatable and its columns.
3. Loop through your file (using FileStream) and populate your datatable.
4. Create a dataview and set to the datatable.
5. Use rowfilter to filter out data you don't want to show.
6. Bind the data to your DataGrid or DataList to display the data onto the page.


Many thanks for your reply, more the kinda reply that I was hoping for.

The method that you have said, trying to understand this:

Does part 3 put the data into the database?

Where do I execute a query/sp to get the correct additional data back? (As more relevant data will be coming back based on a join to the new fields in the table)?

Thanks

passing a parameter?

Hi Guys,

I am just starting on ASP.net. I have created this file so far called database.aspx. The file contains this code:


<%@dotnet.itags.org. Page Language="C#" %>
<script runat="server">


void Page_load(object Sender, EventArgs e)
{

// Discover if SKU QueryString contains a value
string SKU = Request.QueryString["SKU"];
if (SKU == "")
Response.Write ("NO SKU");
else
DataGrid1.DataSource = GetProduct();
DataGrid1.DataBind();
}

System.Data.DataSet GetProduct() {

// Connect to Database
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\\test\\database\\test.mdb";
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);

// SQL
string queryString = "SELECT [Products].Title FROM [Products] WHERE ([Products].SKU = @dotnet.itags.org.SKU)";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;

//Request SKU # from Querystring then locate prodcut based on SKU #

System.Data.IDataParameter dbParam_SKU = new System.Data.OleDb.OleDbParameter();
dbParam_SKU.ParameterName = "@dotnet.itags.org.SKU";
dbParam_SKU.Value = SKU;
dbParam_SKU.DbType = System.Data.DbType.Int32;
dbCommand.Parameters.Add(dbParam_SKU);


System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);

return dataSet;


}

</script>
<html>
<head>
</head>
<body>
<form runat="server">
<br />
<br />
<asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>
<!-- Insert content here -->
</form>
</body>
</html>

I am trying to pass the SKU from the page_load into the GetProducts();

Can someone please help me as I have been trying to work this out all afternoon.

Thanks for the help (any other comments about how to speed up or improve the code are much appricitated).Big Smile [:D]

Muller


<%@. Page Language="C#" %>
<script runat="server">


void Page_load(object Sender, EventArgs e)
{

// Discover if SKU QueryString contains a value
string SKU = Request.QueryString["SKU"];
if (SKU == "")
Response.Write ("NO SKU");
else

{
DataGrid1.DataSource = GetProduct(SKU);
DataGrid1.DataBind();

}
}

System.Data.DataSet GetProduct(String SKU) {

// Connect to Database
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\\test\\database\\test.mdb";
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);

// SQL
string queryString = "SELECT [Products].Title FROM [Products] WHERE ([Products].SKU = @.SKU)";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;

//Request SKU # from Querystring then locate prodcut based on SKU #

System.Data.IDataParameter dbParam_SKU = new System.Data.OleDb.OleDbParameter();
dbParam_SKU.ParameterName = "@.SKU";
dbParam_SKU.Value = SKU;
dbParam_SKU.DbType = System.Data.DbType.Int32;
dbCommand.Parameters.Add(dbParam_SKU);


System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);

return dataSet;


}

</script>
<html>
<head>
</head>
<body>
<form runat="server">
<br />
<br />
<asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>
<!-- Insert content here -->
</form>
</body>
</html>


Im not a C# programmer so the syntax might be wrong, but I would pass the SKU in as a parameter to the GetProduct routine...like GetProduct(SKU)

and update the query to something like:
string queryString = "SELECT [Products].Title FROM [Products] WHERE ([Products].SKU = " + SKU + ")";

Of course, you would need to change the function so you could pass in the SKU...OR you could create a module level variable and change that variable in your page load, and use it in your function.

MajorCats


thankswessamzeidan that works great.

MajorCats - Thats exactly the way I use to do it in ASP but in one of my ASP.NET books it says to do it this way to try and reduce the risk of SQL injection attacks. I need to look into this more but if anyone has any thoughts please email/reply to this postBig Smile [:D]

Thanks again

Muller