| MS Jet Engine Problems with Left Join |
|
 |
Index ‹ dreamweaver
|
- Previous
- 1
- Show/hide PHP results in layersI am working on a site (not uploaded yet) and have come across the following
glitch. Im using PHP to recall information from a database and display in a
table which is placed in a layer DIV When the page loads the layer is not
visible, when the appropriate button is clicked the layer appears (using
autolayers from Project 7) The records are displyed ok but I have given the
repeat region a maximum number of 5 and Im using <<previous & next>>
buttons. When I use the next button to show the next 5 results the layer
refreshes but it resets to not visible, it appers again (with the next 5
results) if I hit the button again I need the layer to stay visible when I ask
for the next/previous records but to hide when I select another layer. PLEASE
HELP ME Louie
- 2
- best ecommerce plug in for order trackingI created a site for a client who is currently only receiving orders by
email/mail and payment by personal check.
We want upgrade the site, add a shopping cart with payment via Paypal, with
USPS shipping costs calculated based on total dollar amount...
i.e.,
$.01 to $100 = $5
$101 to $250 = $7
$251 and up = $10
with an option to ship 2-day express mail for addtitional $10
and 5% tax for orders received from one particular state
Also, we want to be able to show if an item is out of stock when added to
cart, and allow the customer to check an order status by inputting an order #
What's the best third-party plug in that could handle this?
Thanks in advance
- 4
- Connecting to a MySql DB in DW MX2004I have MySql v. 5.0.24 and PHP v. 5.1.5 running on Windows XP Pro. I am using
the IIS web server. The PHP tests fine using a simple clock program. My
problem is that I can?t connect with the MySql database using Dreamweaver MX
2004. I get "An unidentified error has occurred." I have tried older
versions of MySql to no avail. Please help, I must get this to work.
Thanks.
:sad;
- 6
- Calculate Date Difference in session variableI'm using the following to try and establish the number of days difference
between dates from two different record sets. The result using test data should
be 15, but I get 0. No code error message, but no accurate result either. I've
checked the two date values involved, and they're returning the proper data in
the proper format...just can't get the DateDiff function to work in the session
variable...any help greatly apprciated.
Code:
<%Session("Lead")= DateDiff([d], [rsSurvey.Fields.Item("tblShipDat").Value],
[rsOrder.Fields.Item("tblValDat").Value])%>
- 7
- CourseBuilder Drag and DropI'm trying to create a matching interaction in CourseBuilder. I have inserted
both the drag and target items. The problem arises when I test the matching
interaction in my IE browser. To move the "drag" item to match it with the
"target" item, normally you would click directly on top of the "drag" item. I
can't do this. The only way I can select a "drag" item to move it is by
clicking with the mouse BELOW the item itself. Sometimes I must click 1 inch
below the item, sometimes as much as 2 1/2 inches (real distance) below the
item itself. How can I set it up so that the user must click directly on top of
the "drag" item to select and move it?
- 7
- Problem installing extension in DW MX2004 mac editionHi all,
I run DW MX2004 under OS X 10.4.10 on a Mac. I'm having trouble installing the
Rubyweaver 2.0 extension (available from http://rubyweaver.gilluminate.com/)
which should add ruby and rails functionality to DW. According to Extension
Manager it is installed fine but when I try to use DW I get the following
problems:
1. On startup DW throws up a warning message: [Q]The Document Type "" will not
be added because it uses a file extension that is already associated with a
prior document type.[/Q] This message appears three times, I assume for three
different document types.
2. Rails, YML and SQL options are not present in the New Document window
options (they should be).
3. Preferences > Code Format > Tag Library Editor displays an option called
'Rails' - even when the checkbox is ticked, HTML colouring is not present in
.rhtml files.
I contacted the developer about these issues, he assured me that the extension
was developed for and tested on both Windows and OS X platforms, and that
nobody else had reported any problems. He suggested it must be a problem
specific to my system.
So, here's my question: has any one else experienced problems installing
either this or another extension in DW MX2004 on a Mac and does anyone have a
solution/work around.
Thanks in advance for any help.
- 8
- Question on database setupHello,
I am trying to figure something out and thought maybe someone out there knows
the answer! I will give a simple example of what I am trying to do. I am
using MS SQL and ASP VBScript.
Table One: Authors
AuthorID (primary key column, autonumber), AuthorName
Table Two: Books
BookID (primary key column, autonumber), BookName
Table Three: Author_mm_Books (many to many relationship)
Author_mm_BooksID (primary key column, autonumber), AuthorID (Foreign key),
BookID (Foreign Key)
One question that I have: On setting this up, one source of information said
that I didn't need the Author_mm_BooksID column, that I could just set the
AuthorID and BookID both as primary keys. Is that recommended? So the third
table would be:
Table Three: Author_mm_Books (many to many relationship)
AuthorID (primary key), BookID (primary Key)
The second question I have:
On my dynamic page, I would like to pull up a list of books that are written
by a certain author. I can reference the Author_mm_Books table, but in doing
so, I am only bringing up the BookID, and AuthorID, not the Book or Author's
name. Do I have to query all three tables together to get the results I want?
It seems like it would make it a big query to do it that way - I was just
wondering if there was another way of doing it?
Thanks!
Julie
- 8
- Something very strange is happening...I've been using DW for a long time now and have done these sorts of
applications many times. I've never had an instance like this.
I've got a very simple database with some product data in it. I've created an
add product page and an update page that works perfectly fine. Now I just need
my list page with links to the update page.
I've created my list page with a basic recordset pulling in the Name and ID of
all products in the products table. When I test from here it lists them just
as it should: http://www.carvertubs.com/temp/temp/testSQL.gif.
I then simply pull the binding onto the page and add a repeat region to the
table row that is holding the name. I also added the go to details behavior to
this.
The problem is that when I load the page it's only displaying the first record
in the recordset, however, it is repeating in some way...it doesn't just show
it once. The crazy thing is that if you keep refreshing the page it displays a
different number of times each time. For an example look at
www.carvertubs.com/temp/admin/productList.asp and keep hitting F5 and you'll
see what I mean.
So, first, why is this only showing the 1st record in my recordset instead of
repeating through and showing 1 of each record, and second, why is it changing
the number of the items to list all on its own!? There are only 15 records, as
shown in the sample picture provided above, but sometimes it'll show 20 (of the
1st record) and sometimes it'll show just 2 or 3.
Any information on this would be greatly appreciated. I'm stuck on it.
Thanks!
- 8
- asp.net masterpageHow can I control and change the contents within the <head> section of the
master page? I'm using nested master pages, and I need to specify a different
stylesheet for the nested master page. How can I accomplish this?
Master Page:
<%@ Master Language="C#" %>
<%@ Register Src="../UserControls/TopNavigationBar.ascx"
TagName="TopNavigationBar"
TagPrefix="uc2" %>
<%@ Register Src="../UserControls/searchform.ascx" TagName="searchform"
TagPrefix="uc1" %>
<%@ Register Src="../UserControls/MainNavigationBar.ascx"
TagName="MainNavigationBar" TagPrefix="uc3" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Educational Software Solutions - Student, Curriculum Assessment &
Management :: CompassLearning</title>
<link href="../styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="Form1" runat="server">
<div id="container">
etc...
Nested Master Page:
<%@ Master Language="C#" MasterPageFile="~/Templates/SiteMaster.master"
AutoEventWireup="true" CodeFile="TwoColumnMaster.master.cs"
Inherits="TwoColumnMaster" %>
<%@ Register Src="../UserControls/LeftNavigationBar.ascx"
TagName="LeftNavigationBar" TagPrefix="uc1" %>
<asp:content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
<div id="leftcolumn">
<asp:ContentPlaceHolder id="LeftColumn" Runat="Server" />
<uc1:LeftNavigationBar ID="LeftNavigationBar1" runat="server" />
</div>
<div id="rightcolumn">
<asp:ContentPlaceHolder id="RightColumn" Runat="Server" />
</div>
</asp:content>
I originally tried changing the stylesheet in the content page:
public partial class index : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Master.FindControl("MainNavigationBar1").Visible = false;
HtmlLink cssLink = new HtmlLink();
cssLink.Href = "~/styles2.css";
cssLink.Attributes.Add("rel", "stylesheet");
cssLink.Attributes.Add("type", "text/css");
Header.Controls.Add(cssLink);
}
}
That just added another stylesheet reference and didn't replace the master
page stylesheet reference.
I've read several articles to no avail.
Can anyone help on how to achieve this?
- 8
- Dynamically repeat images horizontallyI am wanting to repeat images five across and maybe five rows high. I have
been able to repeat images before a rows, but not as columns. The images will
be changing as the database updates, so there is really no association by
position. Meaning today record ID 1 maybe in position one but it six months
that id will not exist anymore and let's say ID 25 will take that spot.
I have placed the image icon in a table cell and attached it to the image file
name datasource. I have then used repeat region to highlight that cell and the
rest of the row. I just don't know how to populate all the cells to repeat.
I am using the PHP/mySQL model.
Thanks.
- 10
- how to create "forget password"?i don't know if you will receive this message but nevertheless if you have.
you posted a solution to creating a forgot password page that will email a
person their information. below that you provided another solution that you
use. I'm wondering if you can pass the code or a link to the reference
material so that I can create a similar page. thanx.
This is what you originally wrote at the bottom of your post -----> (This is a
simple way to achieve a Forgot Password system, personally I don't email the
Password out, but have the page create an entry in a table for the UserID, and
a unique EventID, which is passed as a link to a display page, which the user
is given in the Email...when they follow the link, their details are shown to
them, the page when it loads runs a Command to change the viewing status from 0
to 1 for that record, and that record can never be viewed again, even if you
knew the URL.)Text
- 12
- Multi Checkboxes Inserted Into MySQL using PHPI have a form that has multiple checkboxes.
A user is going to be selecting checkboxes and on submit I need to have a
value of 1 submitted to the database if the checkbox is selected.
Each checkbox will be related to a row of data in the database that I am
retrieving from the last 14 days, the SQL part I already have and the form
displaying this info.
I know how to submit a form for one of these rows, but how do I submit the
value of all rows at once so that if the row with the record id of 12, 15 & 18
are selected and rows 13, 14, 16 & 17 are not only those rows are updated? I
can even update all rows if necessary making the values of the other 0, I don?t
care I just need to be able to update multiple MySQL records simultaneously
using one form.
Thanks
- 13
- Repeat entries in DB ASP. Hi
I have a booking page in ASP VBScript that before the user submits the data
they have the
option to repeat the booking either every weekday or a specific day in
particular, until a specified date.
I.e. they would like to book a vehicle to collect them at the same time
every Monday to Friday from now until 23rd of July.
Anyone help.
Regards
Simon
- 15
- WAMP and WA ecart installed - now DW cannot make connections to hostI'm trying to learn PHP and recently installed WAMP to use a shopping cart
application from Web Assist.
Now Dreamweaver can't make a connection to host. It gives six possible
reasons why it can't connect:
- The Network cable is unplugged or the network is down. (It's connected and
up)
- The FTP server is down (it's up)
- The FTP host name is incorrect. (it's right)
- The server uses SFTP and the 'Use secure FTP' checkbox isn't checked. (it
doesn't use SFTP)
- The server uses FTP and the 'Use secure FTP' checkbox is checked. (The
checkbox isn't checked)
- Accessing the server requires firewall settings that aren't properly set.
(it doesn't require firewall settings)
I had no problems before WAMP and ecart.
Did I mess something up when I installed WAMP (Apache, MySQL, & PHP)?
Or is the eCart throwing things off?
Does anyone know what could have happened? I'm at my wit's end and could
really use some advice.
Sophia
- 15
- Help defining a dynamic siteI'm a newbie and desperately need some guidance.
I am trying out the demo version of MX Kart and can?t get it to connect
properly. I?ve defined everything as follows:
Local Info
Site name: mx_kart
Local Root Folder: C:\Documents and Settings\Jann\My Documents\0Clients\MX
Kart\
http://localhost/mx_kart
Remote Info
Access: FTP (tests successfully)
Testing Server
Server Model: php mySQL
Access: local/network
Testing Server Folder: C:\program files\apache group\apache2\htdocs\mx_kart
URL prefix: http://www.beaconlights.net/
I am going crazy trying to figure this out. Any help would be greatly
appreciated!
|
| Author |
Message |
StuDawg028
|
 Posted: 2006-1-10 22:03:45 |
Top |
dreamweaver, MS Jet Engine Problems with Left Join
I have been trouble using a left join in my SQL Statement that accesses a MS
Access database I created from a developer tutorial making a forum. I've made
the database and have setup the connection correctly and have been able to
query the database, but I get an error when I try and use a left join. I think
my syntax may be wrong - I've tried several variations.
Here is my original SQL statement:
SELECT *
FROM message_msg LEFT JOIN user_usr ON idusr_msg = id_usr
WHERE idtop_msg = #URL.id_top#
-1:com.inzoom.adojni.ComException: Join expression not supported. in Microsoft
JET Database Engine code=3092 Type=1 Query: SELECT *
FROM message_msg LEFT JOIN user_usr ON idusr_msg = id_usr
WHERE 0 = 1 Join expression not supported.
com.inzoom.adojni.ComException: Join expression not supported. in Microsoft
JET Database Engine code=3092 Type=1
at com.inzoom.ado.Recordset.jniOpenCmd(Native Method)
at com.inzoom.ado.Recordset.open(Recordset.java:88)
at com.inzoom.jdbcado.Statement.createRs(Statement.java:26)
at com.inzoom.jdbcado.Statement.executeQuery(Statement.java:47)
at
coldfusion.server.j2ee.sql.JRunStatement.executeQuery(JRunStatement.java:111)
at
coldfusion.rds.DbFuncsServlet$DbSqlStatementOperator.processCmd(DbFuncsServlet.j
ava:409)
at coldfusion.rds.DbFuncsServlet.processCmd(DbFuncsServlet.java:78)
at coldfusion.rds.RdsServlet.doPost(RdsServlet.java:57)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.rds.RdsFrontEndServlet.doPost(RdsFrontEndServlet.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
com.inzoom.jdbcado.JdbcAdoException: com.inzoom.adojni.ComException: Join
expression not supported. in Microsoft JET Database Engine code=3092 Type=1
Query: SELECT *
FROM message_msg LEFT JOIN user_usr ON idusr_msg = id_usr
WHERE 0 = 1 Join expression not supported.
at com.inzoom.jdbcado.Statement.createRs(Statement.java:28)
at com.inzoom.jdbcado.Statement.executeQuery(Statement.java:47)
at
coldfusion.server.j2ee.sql.JRunStatement.executeQuery(JRunStatement.java:111)
at
coldfusion.rds.DbFuncsServlet$DbSqlStatementOperator.processCmd(DbFuncsServlet.j
ava:409)
at coldfusion.rds.DbFuncsServlet.processCmd(DbFuncsServlet.java:78)
at coldfusion.rds.RdsServlet.doPost(RdsServlet.java:57)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.rds.RdsFrontEndServlet.doPost(RdsFrontEndServlet.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Here is a variation:
SELECT *
FROM message_msg LEFT JOIN user_usr ON message_msg.idusr_msg = user_usr.id_usr
WHERE idtop_msg = #URL.id_top#
When I test this statement, I receive the error:
-1:com.inzoom.adojni.ComException: No value given for one or more required
parameters. in Microsoft JET Database Engine code=3088 Type=1 Query: SELECT *
FROM message_msg LEFT JOIN user_usr ON message_msg.idusr_msg = user_usr.id_usr
WHERE 0 = 1 No value given for one or more required parameters.
com.inzoom.adojni.ComException: No value given for one or more required
parameters. in Microsoft JET Database Engine code=3088 Type=1
at com.inzoom.ado.Recordset.jniOpenCmd(Native Method)
at com.inzoom.ado.Recordset.open(Recordset.java:88)
at com.inzoom.jdbcado.Statement.createRs(Statement.java:26)
at com.inzoom.jdbcado.Statement.executeQuery(Statement.java:47)
at
coldfusion.server.j2ee.sql.JRunStatement.executeQuery(JRunStatement.java:111)
at
coldfusion.rds.DbFuncsServlet$DbSqlStatementOperator.processCmd(DbFuncsServlet.j
ava:409)
at coldfusion.rds.DbFuncsServlet.processCmd(DbFuncsServlet.java:78)
at coldfusion.rds.RdsServlet.doPost(RdsServlet.java:57)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.rds.RdsFrontEndServlet.doPost(RdsFrontEndServlet.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
com.inzoom.jdbcado.JdbcAdoException: com.inzoom.adojni.ComException: No value
given for one or more required parameters. in Microsoft JET Database Engine
code=3088 Type=1 Query: SELECT *
FROM message_msg LEFT JOIN user_usr ON message_msg.idusr_msg = user_usr.id_usr
WHERE 0 = 1 No value given for one or more required parameters.
at com.inzoom.jdbcado.Statement.createRs(Statement.java:28)
at com.inzoom.jdbcado.Statement.executeQuery(Statement.java:47)
at
coldfusion.server.j2ee.sql.JRunStatement.executeQuery(JRunStatement.java:111)
at
coldfusion.rds.DbFuncsServlet$DbSqlStatementOperator.processCmd(DbFuncsServlet.j
ava:409)
at coldfusion.rds.DbFuncsServlet.processCmd(DbFuncsServlet.java:78)
at coldfusion.rds.RdsServlet.doPost(RdsServlet.java:57)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.rds.RdsFrontEndServlet.doPost(RdsFrontEndServlet.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Would anyone be able to help me out with this problem? I would appreciate all
the help you can give me. Thanks.
|
| |
|
| |
|
Lionstone
|
| Posted: 2006-1-10 22:16:00 |
Top |
dreamweaver >> MS Jet Engine Problems with Left Join
Don't abbreviate the join type and see what happens. (A LEFT OUTER JOIN B ON
A.Field=B.Field)
|
| |
|
| |
|
Spacecase3785
|
| Posted: 2006-1-11 3:33:00 |
Top |
dreamweaver >> MS Jet Engine Problems with Left Join
Is idtop_msg in message_msg or user_usr ?
If you'll notice:
WHERE 0 = 1
this is how it was parsed (always empty set...)
If idtop_msg is in user_usr then your join needs a nested select with the
WHERE statment in it. (don't forget the parenthesis)
Also, it is always better to specify fields with table.field, this will avoid
ambiguity...
|
| |
|
| |
|
Spacecase3785
|
| Posted: 2006-1-11 3:53:00 |
Top |
dreamweaver >> MS Jet Engine Problems with Left Join
Also, use Response.Write(strSQL) to debug SQL that way you can see what is actually sent, where strSQL is the SQL string you are building...
|
| |
|
| |
|
| |
|
Index ‹ dreamweaver |
- Next
- 1
- PHP: sorting years and months in VARCHAR fieldsI'm on the PHP4 learning curve and wondered if I could pick someone's PHP
brains.
I have three fields in a database (all VARCHAR): year, month, title
e.g. three typical records in MySql:
2005, April, Voice of ANATS Vol.18, No. 2
2005, February, Voice of ANATS Vol.18, No. 1
2004, November, Voice of ANATS Vol.17, No. 3
I need to sort them a) by year ASC then, b) by month ASC
So the output should be:
2004 November Voice of ANATS Vol.17, No. 3
2005 February Voice of ANATS Vol.18, No. 1
2005 April Voice of ANATS Vol.18, No. 2
What the best way of tackling this? arrays? order by?
Do I create a custom list (Jan, Feb, Mar.....) and sort by that?
I'm currently sorting them crudely simply by Title ASC.
But this creates problems if end users enter "No.1" instead of "No. 1"
(space between the period and the 1)
--
Regards
John Waller
- 2
- Only Safari won't show home page imageHelo
Having problems with home page image showing in only Safari (
www.truthandlife.info ). May be a css problem, but I don't know...
Originally, we had to alter the drop down menu becasue it wouldn't work on
Safari, so a friend fixed that but that fix took away the main image - he
writes:
"I found some other information that suggested setting the ClientTarget
attribute to ?uplevel? when you detect the Safari or Opera browsers.
I went ahead and implemented that by creating a base class called BasePage (in
the App_Code folder) and made every page load derive from it using the
?Inherits? parameter. This seemed to solve the problem on Safari (I don?t have
Opera) without affecting IE7. Note that all new pages you create need to have
the Inherits=?BasePage? tag set in their <Page> element.
So all is good in that the submenus pop up as we would expect?but there is a
problem with the graphic on the default page. The main image doesn?t load on
the Safari browser unless I remove that ClientTarget=?uplevel? statement. If I
remove it, then the menus don?t work."
===============
So does anyone know what might be the problem and/or fix?
Thanks
KB
- 3
- Recordset - See anything wrong with this?I've been trying to pull in this record but can't, for the life of me,
get it to actually pull in what I want. I thought I'd just throw this
out for someone to look at to see if there is anything obvious here that
I am overlooking.
Basically , I fill out a for, submit it and it goes to this page that
pulls in the recordset based on the sessions set. The items are being
stored in the database and I've verified that but once there, this
recordset isn't able to pull them out.
Thanks
<%
Dim rsShipping__MMColParam
rsShipping__MMColParam = "11992"
If (Session("ssCustID") <> "") Then
rsShipping__MMColParam = Session("ssCustID")
End If
%>
<%
Dim rsShipping__MMColParam2
rsShipping__MMColParam2 = "837413105"
If (Session("SessionID") <> "") Then
rsShipping__MMColParam2 = Session("SessionID")
End If
%>
<%
Dim rsShipping
Dim rsShipping_cmd
Dim rsShipping_numRows
Set rsShipping_cmd = Server.CreateObject ("ADODB.Command")
rsShipping_cmd.ActiveConnection = MM_connShnta_STRING
rsShipping_cmd.CommandText = "SELECT * FROM atblShipAddress WHERE
atblShipAddress.CustomerKey = ? AND atblShipAddress.ShipSessionID = ?"
rsShipping_cmd.Prepared = true
rsShipping_cmd.Parameters.Append
rsShipping_cmd.CreateParameter("param1", 5, 1, -1,
rsShipping__MMColParam) ' adDouble
rsShipping_cmd.Parameters.Append
rsShipping_cmd.CreateParameter("param2", 200, 1, 50,
rsShipping__MMColParam2) ' adVarChar
Set rsShipping = rsShipping_cmd.Execute
rsShipping_numRows = 0
%>
- 4
- redirect?!?!?Hi i am wondering if anybody knows how to redirect a user to another page if a
statement returns true? Here is the code, I am using PHP:
// check if database has content
if ($totalRows_login != 1)
{
echo'you are not logged in';
}
else{
echo ("addimage.php"); // clearly wrong, but how would i go about redirecting
the user to another page?
}
any help would be great
Bethan
- 5
- "Email this Page" scriptI would like a link to "Email this Page" to a predetermined recipient. I dont have CF.
Does anyone know how to do this?
Thanks.
- 6
- Slow network connection only in DreamweaverI have a Site setup in Dreamweaver that points to the development server hosted
at another facility. When I map to this drive outside of Dreamweaver in
Explorer, it's a little slow, but when I'm working in Dreamweaver in local
view, it's REALLY slow. It's almost like it's refreshing every minute and just
hangs there.
I tried using the cache on the local server, but the cache runs painfully slow
when it first connects to the server.
Is there a setting in Dreamweaver that could curtail this, or is this more of
a network issue unrelated?
- 7
- Synatax Query - Less than or Equal toRunning on Linux, Apache, MySQL, PHP
I have an issue with a date query - possibly created by the MySQL format
YYYY-MM-DD
I want to create a recordset where activities are less than or equal to
today's date.
I've managed most of it but the result seems only to show less than and not
less than and equal to.
This is the part of the query that is in question:
CONTNOTES.ACTDATE<='coldatetil'
I have tried =< without success
Any ideas?
- 8
- Problem Retrieving CookiesI'm trying to set a cookie for a Media Page so that before someone views some
photo pages for the first time, a page comes up with an agreement to the terms
of use of the photo's etc. After they agree, they should be able to go
straight to the photo pages.
I keep getting an error when I try to check to see if the cookie exists. I
ended up "initializing" the cookie just so I could get around the problem so I
could continue my testing and get everything else to work. Now I need to
remove that line, and I don't know what the problem is. Here's my code:
<%@LANGUAGE="VBSCRIPT"%>
<% response.buffer = true %>
<%
response.cookies("MYCOOKIE")("Terms")="No"
If Request.Cookies("MYCOOKIE")("Terms")="Yes" Then
response.write(request.cookies("MYCOOKIE")("Terms"))
response.Redirect("film_media.asp")
End If
%>
This is the error I get when I remove the line that sets the cookie to No:
Server Error in '/' Application.
--------------------------------------------------------------------------------
Runtime Error
Description: An application error occurred on the server. The current custom
error settings for this application prevent the details of the application
error from being viewed remotely (for security reasons). It could, however, be
viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable
on remote machines, please create a <customErrors> tag within a "web.config"
configuration file located in the root directory of the current web
application. This <customErrors> tag should then have its "mode" attribute set
to "Off".
I was hoping someone might have a quick answer for me so that I don't have to
get one of our server guys to help me to enable the details of the specific
error message.
Any ideas?
Thanks
- 9
- some one please help!!!!!!can some one please help i am doing a project and i am building a site where
people can advertise there cars for sale like the www.buyandsell.ie need help
with 5. problems .
1.how do i set up a login and register section of the site i have the homepage
almost done all the buttons are there for the login and register.
2.how do i add a registration menu for example county sex age address the
county and sex would need to be a drop down menu but i dont know where to start.
3.where will all the cutomers details be stored and how much memory will it
need, will all the customers details be save to one file.
4.i also need to know how to set up an option for people to add pictures and a
detail decription of there car with out me having to input there details for
them(self-maintaining).
5.i want to have sections for the site where people can view cars by make and
price for example ?1001-?2000 ?2001-?3000 and so on is there any easy way of
doing this with out having alot of pages for each of the section
im using macromedia studio 8
- 10
- Limit records in inserted in database tableHi Guys,
I can manage the Insert record with ease in DW, but im wondering how i can
only allow between 5-6 records to be added to a table?
If the user tries to add a record and there are 5-6 records in the database
already I want to refuse the insert and give a message to say so...
Thanks for any thoughts.
Tag
- 11
- Problem creating BehaviorsI'm porting some of my GoLive Actions over to DW Behaviors and am having some
problems.
The support functions in my Behavior .js file, following the main function,
are not being included in the page where the function is used. The globals at
the top of the .js file are also not included. I'm working with a trial version
of DW so I don't have much documentation on creating Behaviors.
Appreciate any help with this?
- 12
- Can't View Stored Procedures in SQL2005I created a page that calls a stored procedure. Initially, the SP was on
SQL2000, but has since been upgraded to SQL2005. The SP still runs, but I
cannot view the SP in the Database items from the Command screen. I can see the
Tables and Views, but I get an error "Error calling GetProcedures". I need to
create othe pages from other SP and need to be able to select a SP. Can anyone
help?
- 13
- Distinct records onlyHi
I'm building a gallery app in vb.net with sql2000 and am sort of stuck so
any advice would be gratefully received, heres the trouble
I have a user control that displays latest photos populated from an SP
(Select iFilename, iDate, iUserID from tblImages order by iDate Desc)
works like a charm however if a user uploads 5 photos all the latest photos
on the homepage will be theirs. I'd like to only retrieve only records with
a unique userID
I tried
Select distinct iUserID iFilename, iDate, from tblImages order by iDate Desc
but it didn't work, I tried google but didn't find anything similar and a
few others that only retrieved totally unique records.
I'm up against a deadline and this is the last bit so any advice gratefully
received
- 14
- LCID issueHi. using access/asp/vbscript
Is it possible to set LCID value on one page only at a website? How?
Thanx.
Bjorn.
- 15
- create web service with Dreamweaver mx 2004hi all
i am new to this dreamweaver mx 2004.
I want to know a small information.
Is it possible to create a new web service with asp.net using dreamweaver mx
2004 ??
If possible how ? any tutorial ?
|
|
|
