473,895 Members | 3,051 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

<%=ray%> online query analzyer for access 2000

Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when
you adjust underlying tables and queries offline and then have to overwrite
the live database?

Many thanks Jason
Jul 19 '05 #1
24 2731
This is probably the link that I posted. (Be aware that this page will
display an unprofessional word on your monitor, so if you work at a church
or something, make sure you don't offend anyone.)

http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

And here is something that I posted to another forum a few months back.

<quote>

You can modify you Acccess db with sql commands if you can't take your
site off line. You can just make yourself a password protected SQL
command page like so:
<form name="frmDataba se" method="post" action="sql.asp ">
Enter SQL Command Below<BR>
<textarea name="txtSQL" style="width: 550px; height: 100px;"></textarea>
<input name="cmdSubmit " type="submit" value="Submit">
</form>


Then post that to a page like:

sSQL = Request.Form("t xtSQL")
''create your connection and connect here
YourConnectionj ADO.Execute sSQL

You can pass things like "ALTER TABLE [TableName] ADD COLUMN
NameOfYourNewCo lumn text(100)"

Just make sure you protect you pages heavily! If unauthorized person
gets in there, he could delete all your data, drop your tables, etc.
</quote>

Ray at work

"jason" <ja***@catamara nco.com> wrote in message
news:ek******** *****@tk2msftng p13.phx.gbl...
Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when
you adjust underlying tables and queries offline and then have to overwrite the live database?

Many thanks Jason

Jul 19 '05 #2
Thanks Ray...although the only curve balls with his examples are that they
are in JScript and he seems to use a Windows Script Component which will not
be avialable to me to use on my web host......
I don't suppose you have come across any pure asp examples...?

Thanks again
Jason
"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:#S******** ******@tk2msftn gp13.phx.gbl...
This is probably the link that I posted. (Be aware that this page will
display an unprofessional word on your monitor, so if you work at a church
or something, make sure you don't offend anyone.)

http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

And here is something that I posted to another forum a few months back.

<quote>

You can modify you Acccess db with sql commands if you can't take your
site off line. You can just make yourself a password protected SQL
command page like so:
<form name="frmDataba se" method="post" action="sql.asp ">
Enter SQL Command Below<BR>
<textarea name="txtSQL" style="width: 550px; height: 100px;"></textarea>
<input name="cmdSubmit " type="submit" value="Submit">
</form>


Then post that to a page like:

sSQL = Request.Form("t xtSQL")
''create your connection and connect here
YourConnectionj ADO.Execute sSQL

You can pass things like "ALTER TABLE [TableName] ADD COLUMN
NameOfYourNewCo lumn text(100)"

Just make sure you protect you pages heavily! If unauthorized person
gets in there, he could delete all your data, drop your tables, etc.
</quote>

Ray at work

"jason" <ja***@catamara nco.com> wrote in message
news:ek******** *****@tk2msftng p13.phx.gbl...
Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when you adjust underlying tables and queries offline and then have to

overwrite
the live database?

Many thanks Jason


Jul 19 '05 #3
I am also looking at this code snippet -

http://www.codetoad.com/asp_query_displayer.asp
"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:#S******** ******@tk2msftn gp13.phx.gbl...
This is probably the link that I posted. (Be aware that this page will
display an unprofessional word on your monitor, so if you work at a church
or something, make sure you don't offend anyone.)

http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

And here is something that I posted to another forum a few months back.

<quote>

You can modify you Acccess db with sql commands if you can't take your
site off line. You can just make yourself a password protected SQL
command page like so:
<form name="frmDataba se" method="post" action="sql.asp ">
Enter SQL Command Below<BR>
<textarea name="txtSQL" style="width: 550px; height: 100px;"></textarea>
<input name="cmdSubmit " type="submit" value="Submit">
</form>


Then post that to a page like:

sSQL = Request.Form("t xtSQL")
''create your connection and connect here
YourConnectionj ADO.Execute sSQL

You can pass things like "ALTER TABLE [TableName] ADD COLUMN
NameOfYourNewCo lumn text(100)"

Just make sure you protect you pages heavily! If unauthorized person
gets in there, he could delete all your data, drop your tables, etc.
</quote>

Ray at work

"jason" <ja***@catamara nco.com> wrote in message
news:ek******** *****@tk2msftng p13.phx.gbl...
Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when you adjust underlying tables and queries offline and then have to

overwrite
the live database?

Many thanks Jason


Jul 19 '05 #4
Hey Ray - I got the code toad working example up and running and it works
great for simple selects but how does one syntaxically exec a stored
query...do you use the same syntax as asp or do you assume you are inside
the access database:

For instance,

SQL = "EXEC qry_ListingPric eChanges_Condit ion @LID=Null, @ConID=" & ConID &
" ,@ActiveID=" & ActiveID 'Response.Write SQL 'Response.END set rs =
cnn.execute(SQL

If I keep the above simple and attempt to run it via the query analzyer:

qry_ListingPric eChanges_Condit ion @LID=Null,@ConI D=Null,@ActiveI D=Null

....I get 0 records affected - but is this the way I should be writing it or
like this:

EXEC qry_ListingPric eChanges_Condit ion @LID=Null,@ConI D=Null,@ActiveI D=Null

Either way seems to bring 0 records....any advice?

Thanks
Jason
"jason" <ja***@catamara nco.com> wrote in message
news:O3******** ******@TK2MSFTN GP09.phx.gbl...
I am also looking at this code snippet -

http://www.codetoad.com/asp_query_displayer.asp
"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:#S******** ******@tk2msftn gp13.phx.gbl...
This is probably the link that I posted. (Be aware that this page will
display an unprofessional word on your monitor, so if you work at a church
or something, make sure you don't offend anyone.)

http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

And here is something that I posted to another forum a few months back.

<quote>

You can modify you Acccess db with sql commands if you can't take your
site off line. You can just make yourself a password protected SQL
command page like so:
<form name="frmDataba se" method="post" action="sql.asp ">
Enter SQL Command Below<BR>
<textarea name="txtSQL" style="width: 550px; height: 100px;"></textarea>
<input name="cmdSubmit " type="submit" value="Submit">
</form>


Then post that to a page like:

sSQL = Request.Form("t xtSQL")
''create your connection and connect here
YourConnectionj ADO.Execute sSQL

You can pass things like "ALTER TABLE [TableName] ADD COLUMN
NameOfYourNewCo lumn text(100)"

Just make sure you protect you pages heavily! If unauthorized person
gets in there, he could delete all your data, drop your tables, etc.
</quote>

Ray at work

"jason" <ja***@catamara nco.com> wrote in message
news:ek******** *****@tk2msftng p13.phx.gbl...
Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000 database.... could you provide refresher links on this or possibly some starter code?

I am just so sick of the syncronization problems that come into play

when you adjust underlying tables and queries offline and then have to

overwrite
the live database?

Many thanks Jason



Jul 19 '05 #5
There are some tools listed here, several of them are also valid for Access,
and of those, most are free (or relatively cheap).

http://www.aspfaq.com/2442

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"jason" <ja***@catamara nco.com> wrote in message
news:ek******** *****@tk2msftng p13.phx.gbl...
Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when
you adjust underlying tables and queries offline and then have to overwrite the live database?

Many thanks Jason

Jul 19 '05 #6
I'm sorry. I don't understand exactly what you're asking. Are you trying
to get the "0 records affected" message back in your page, or are you saying
that you're not sure why there were ZERO records affected as opposed to >0?

Ray at work

"jason" <ja***@catamara nco.com> wrote in message
news:eE******** ******@TK2MSFTN GP11.phx.gbl...

SQL = "EXEC qry_ListingPric eChanges_Condit ion @LID=Null, @ConID=" & ConID & " ,@ActiveID=" & ActiveID 'Response.Write SQL 'Response.END set rs =
cnn.execute(SQL

If I keep the above simple and attempt to run it via the query analzyer:

qry_ListingPric eChanges_Condit ion @LID=Null,@ConI D=Null,@ActiveI D=Null

...I get 0 records affected - but is this the way I should be writing it or like this:

EXEC qry_ListingPric eChanges_Condit ion @LID=Null,@ConI D=Null,@ActiveI D=Null
Either way seems to bring 0 records....any advice?

Thanks
Jason

Jul 19 '05 #7
Excuse confusion...

The query analzyer from codetoad works great with simple select and delete
queries.

However, when it comes to ACTION queries I am at a loss as to how to CREATE
eg:

1. A NEW QUERY (eg qry_insert_NewL isting)
2. A NEW TABLE (eg: tblYachts)
3. ...and finally, I am unclear as to how to pass parameters to the query in
the analzyer window as this does not seem to be valid:
qry_ListingPric eChanges_Condit ion @LID=Null,@ConI D=Null,@ActiveI D=Null

Thanks
Jason

ps: Is there a really good straightfoward site that deals with action
queries inside Access 2000? A google search is not bringing
up great results....
"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:OD******** *****@tk2msftng p13.phx.gbl...
I'm sorry. I don't understand exactly what you're asking. Are you trying
to get the "0 records affected" message back in your page, or are you saying that you're not sure why there were ZERO records affected as opposed to
0?

Ray at work

"jason" <ja***@catamara nco.com> wrote in message
news:eE******** ******@TK2MSFTN GP11.phx.gbl...

SQL = "EXEC qry_ListingPric eChanges_Condit ion @LID=Null, @ConID=" &
ConID &
" ,@ActiveID=" & ActiveID 'Response.Write SQL 'Response.END set rs =
cnn.execute(SQL

If I keep the above simple and attempt to run it via the query analzyer:

qry_ListingPric eChanges_Condit ion @LID=Null,@ConI D=Null,@ActiveI D=Null

...I get 0 records affected - but is this the way I should be writing it

or
like this:

EXEC qry_ListingPric eChanges_Condit ion

@LID=Null,@ConI D=Null,@ActiveI D=Null

Either way seems to bring 0 records....any advice?

Thanks
Jason


Jul 19 '05 #8
Thanks - those links are helpful.
"Aaron Bertrand [MVP]" <aa***@TRASHasp faq.com> wrote in message
news:uA******** *****@TK2MSFTNG P11.phx.gbl...
There are some tools listed here, several of them are also valid for Access, and of those, most are free (or relatively cheap).

http://www.aspfaq.com/2442

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"jason" <ja***@catamara nco.com> wrote in message
news:ek******** *****@tk2msftng p13.phx.gbl...
Hi Ray...a while ago you explained an elegant solution to enable me to
CREATE and EDIT existing tables and queries inside my online access 2000
database.... could you provide refresher links on this or possibly some
starter code?

I am just so sick of the syncronization problems that come into play when you adjust underlying tables and queries offline and then have to

overwrite
the live database?

Many thanks Jason


Jul 19 '05 #9

"jason" <ja***@catamara nco.com> wrote in message
news:um******** ******@TK2MSFTN GP12.phx.gbl...
Excuse confusion...

The query analzyer from codetoad works great with simple select and delete
queries.

However, when it comes to ACTION queries I am at a loss as to how to CREATE eg:

1. A NEW QUERY (eg qry_insert_NewL isting)
Yeah, I'm not sure how you create queries with SQL in an Access database.
Where's Bob Barrows?
2. A NEW TABLE (eg: tblYachts)
This thing that you're using, does it just execute whatever adhoc query you
throw at it? That's all that I've used. And if it's like that, you'd do
something like:

CREATE TABLE tblYachts1 (YachtID AUTOINCREMENT PRIMARY KEY, YachtName
TEXT(255), YachtPrice NUMBER)

3. ...and finally, I am unclear as to how to pass parameters to the query in the analzyer window as this does not seem to be valid:
qry_ListingPric eChanges_Condit ion @LID=Null,@ConI D=Null,@ActiveI D=Null


Here's a decent link.
http://www.asp101.com/samples/viewas...dqueries%2Easp

Ray at work
Jul 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2805
by: Eric A. Forgy | last post by:
Hello, I am just learning Java and am trying to write a method that does something like //=========================================== public Static List find(double array,double val,String relationalOp) { List list = new ArrayList();
10
2364
by: Gianpiero Colagiacomo | last post by:
VBScript: Can anyone help me figure out why the image within this IF statement shows as a place holder rather than the image itself when the statement is returning true? If I remove the IF the image shows... <% If (events.Fields.Item("picURL").Value) <> "" Then
5
19873
by: David Lozzi | last post by:
I am using an upload util and I was told I need this option, enctype="multipart/form-data", in my FORM tag. How do I reference the other form fields within the form from ASP? THanks, -- David Lozzi Associated Business & Technology Group www.associatedbtg.com
8
3011
by: Eric Bragas | last post by:
What is this? <img src="{$ ImagesDir}/photo.gif"> I KNOW what an HTML image tag looks like. But what do you call that in the file source? Is it like a virtual directory in IIS? It's some type of variable obviously, but can somebody tell me what it's called so I can research how it works? thanks.
1
3454
by: Burton Figg | last post by:
I have a SELECT statement which holds a list of times (for adding appointments to a database): e.g. <select name="time" id="time" size="3" multiple> <option value="00:00">00:00</option> <option value="00:30">00:30</option> <option value="01:00">01:00</option> <option value="01:30">01:30</option>
6
1613
by: Christina | last post by:
I want to read a classic HTML Form using the ASP Request object on the server. This is a common approach. But how can I read all the contents of a listbox (the <select> tag)? Best regards, Christina
3
3220
by: Ray Tayek | last post by:
hi, trying to use an xslt to make an xslt. trying something like: <?xml version="1.0" encoding="UTF-8"?> <?xmlspysamplexml H:\java\projects\spy1\spy\inputDocumentMap.xml?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:template match="/inputDocumentMap"> <xsl:element name="xsl:template" match="/inputDocument">...
9
5013
by: Ross | last post by:
it seems that it is only supported by w3c but not IE or netscape, but what is a w3c browser ?
0
9833
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11247
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10469
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9648
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8025
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6066
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4684
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4282
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3293
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.