Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
16
Web Server - Ask For Help / Re: Priming MSSQL Identity field
« on: February 03, 2009, 12:33:26 PM »
Neil. No ideas on your problem, but EmaulateAutoNum is working for me.
e.g. I have a table "DimIndicator" with database driver of "MSSQL".
On the table options it has "EmulateAutoNumKey"=1.
(I'm using 1 instead of true here).
The table has an identity field (not a guid, but a plain long) of "Id_Indicator".
The field options are:
"IsIdentity"=true
"Autonumber"=1,1
The key is called "pk_DimIndicator"
Attributes are: RequireUniqueValue, PrimaryKey, CaseSensitive.
And columns is just "Id_Indicator".
I can confirm this combination is working fine for me in both my win32 app, and my nettalk webserver.
Alan
[attachment deleted by admin]
e.g. I have a table "DimIndicator" with database driver of "MSSQL".
On the table options it has "EmulateAutoNumKey"=1.
(I'm using 1 instead of true here).
The table has an identity field (not a guid, but a plain long) of "Id_Indicator".
The field options are:
"IsIdentity"=true
"Autonumber"=1,1
The key is called "pk_DimIndicator"
Attributes are: RequireUniqueValue, PrimaryKey, CaseSensitive.
And columns is just "Id_Indicator".
I can confirm this combination is working fine for me in both my win32 app, and my nettalk webserver.
Alan
[attachment deleted by admin]
17
Web Server - Ask For Help / Unique key with two components no longer working
« on: February 02, 2009, 06:10:43 PM »
I've been using browses which have unique keys which have two components.
A parentId and a ChildId (autonumber).
A browse/form on this table was working in earlier versions but I've noticed it not longer works.
e.g. one table "Uni_BranchMachine" has a single unique key "UniBM_pk_BranchMachine" with two field: uniBM:Id_Branch + uniBM:MachineNumber
I notice that when I click on the change button I get a
GET /browseuni_updatemachine?&_ParentProc=&_Clicked=1&id=uniBM:Id_Branch&Value=3&_=
but to uniquely identify the row, it needs to have
uniBM:id_Branch=51 and uniBM:MachineNumber=3
For some reason it is only using the 2nd key component (machinenumber=3), and then it tried to lookup the record by setting the 1st key component to the value of the 2nd key component.
Please can you confirm --- are unique multi-component keys supported? (it was working fine in an earlier version April last year).
Note - you can reproduce in e.g. web31 accounts by changing the BrowseLineItems to use the dual component LIN:InvKey (which is unique).
Regards,
Alan Telford
A parentId and a ChildId (autonumber).
A browse/form on this table was working in earlier versions but I've noticed it not longer works.
e.g. one table "Uni_BranchMachine" has a single unique key "UniBM_pk_BranchMachine" with two field: uniBM:Id_Branch + uniBM:MachineNumber
I notice that when I click on the change button I get a
GET /browseuni_updatemachine?&_ParentProc=&_Clicked=1&id=uniBM:Id_Branch&Value=3&_=
but to uniquely identify the row, it needs to have
uniBM:id_Branch=51 and uniBM:MachineNumber=3
For some reason it is only using the 2nd key component (machinenumber=3), and then it tried to lookup the record by setting the 1st key component to the value of the 2nd key component.
Please can you confirm --- are unique multi-component keys supported? (it was working fine in an earlier version April last year).
Note - you can reproduce in e.g. web31 accounts by changing the BrowseLineItems to use the dual component LIN:InvKey (which is unique).
Regards,
Alan Telford
18
Web Server - Ask For Help / Re: insert not restoring position properly on multiple tab form
« on: February 02, 2009, 05:10:12 PM »
Hi Bruce
I've wanted this to work for a long time too.
I've just tested my scenario and it's not working.
NT4.31 pr30 + firefox 3
The web server default is XP-TABS.
I have a memory form with "Default" as type.
Tabs 1-2 has form fields.
Tabs 3-8 have browses (some file loaded, some page loaded).
I usually use inline change buttons on the browse row.
If I select tab 3, press change (on the browse row), and then press SAVE on the form, it is ALWAYS resetting me back to tab 1.
So definitely not working for me here.
Alan
I've wanted this to work for a long time too.
I've just tested my scenario and it's not working.
NT4.31 pr30 + firefox 3
The web server default is XP-TABS.
I have a memory form with "Default" as type.
Tabs 1-2 has form fields.
Tabs 3-8 have browses (some file loaded, some page loaded).
I usually use inline change buttons on the browse row.
If I select tab 3, press change (on the browse row), and then press SAVE on the form, it is ALWAYS resetting me back to tab 1.
So definitely not working for me here.
Alan
19
Web Server - Ask For Help / Re: 4.31pre10 fails to remember current tab
« on: August 13, 2008, 12:42:12 PM »
Hmmm. the return to the right row after an UPDATE is definitely more important than after an INSERT.
Infact, I could *almost* live without the insert, but definitely not without the update.
Good work! I look forward to trying out PR11.
Infact, I could *almost* live without the insert, but definitely not without the update.
Good work! I look forward to trying out PR11.
20
Web Server - Ask For Help / 4.31pre10 fails to remember current tab
« on: August 12, 2008, 02:12:17 PM »
Hi
I finally got time to download the latest preview release and give it a quick whirl.
I have a number of netwebform with multiple tabs. Tab 1+2 are memory forms with a save button. Tab 3-6 are various browses with dropdown filters etc.
I open the form, change to tab3, press change on a row, make changes, and press save.
The table is updated, and nettalk reloads the form and switches from TAB3 to TAB1.
i.e. if a user has 10 fields to change on tab3, he has to go through a rigmarole
- select tab 3
- press next/prev to locate the appropriate row in page-loaded browse
- press chg
- make changes
- wait for page to reload
- repeat from top again.
It would be wonderful if when the page reloaded (after saving a record on the browse) that it remembered what the current tab was.
The related issue (of selecting the row just changed) when the browse reloads looks *GREAT*. It's working nicely.
Alan
I finally got time to download the latest preview release and give it a quick whirl.
I have a number of netwebform with multiple tabs. Tab 1+2 are memory forms with a save button. Tab 3-6 are various browses with dropdown filters etc.
I open the form, change to tab3, press change on a row, make changes, and press save.
The table is updated, and nettalk reloads the form and switches from TAB3 to TAB1.
i.e. if a user has 10 fields to change on tab3, he has to go through a rigmarole
- select tab 3
- press next/prev to locate the appropriate row in page-loaded browse
- press chg
- make changes
- wait for page to reload
- repeat from top again.
It would be wonderful if when the page reloaded (after saving a record on the browse) that it remembered what the current tab was.
The related issue (of selecting the row just changed) when the browse reloads looks *GREAT*. It's working nicely.
Alan
21
Web Server - Ask For Help / Re: How do I block certain IPs?
« on: August 11, 2008, 01:56:21 PM »
I modified my LogonPage and IndexPage so that both have the following XHTML routine at location: "Inside <HEAD>"
I'm hoping that should elimitate the problem of robot crawlers.
Code: [Select]
<meta NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW, NOARCHIVE">I'm hoping that should elimitate the problem of robot crawlers.
22
Web Server - Ask For Help / Re: Server Connection Failed
« on: August 10, 2008, 12:45:20 PM »
Bruce,
It was my issue that had the one app with two servers - 1 HTTPS and 1 HTTP- on the same window. This created error -12263 in the clients browser whenever the request took too long.
The workaround you gave me was to remove the HTTP server, and just use the HTTPS.
And I must say, I haven't seen the error again since then.
So the thread was via email around 14-Mar-08.
Cheers,
Alan
It was my issue that had the one app with two servers - 1 HTTPS and 1 HTTP- on the same window. This created error -12263 in the clients browser whenever the request took too long.
The workaround you gave me was to remove the HTTP server, and just use the HTTPS.
And I must say, I haven't seen the error again since then.
So the thread was via email around 14-Mar-08.
Cheers,
Alan
23
Web Server - Ask For Help / How do I block certain IPs?
« on: July 31, 2008, 04:37:00 PM »
After implementing some logging on my nettalk site yesterday, I've discovered about 300 attempts from a certain IP to login. They haven't succeeded yet.
What should I do to prevent this? Any ideas/suggestions?
Thanks,
Alan
What should I do to prevent this? Any ideas/suggestions?
Thanks,
Alan
24
Web Server - Ask For Help / Re: track incoming IP address
« on: July 31, 2008, 12:44:46 PM »
Thanks for sharing. That helps!
I'm slightly puzzled because it looks as if your "HITPAGE" is always going to be "HitLogger" and is therefore redundant (unless you have multiple hit logger procedures).
So I guess the real valuable part is the "RequestReferrer" which is always the page which calls the hitlogger.
I had a play and ending up putting the logging code into my "PageHeaderTag".
So, any pages which use the common header will automatically log their information. This saved me from having to insert the code into my pages.
Thanks again for sharing. i'd been meaning to add some logging for a long time.
I'm slightly puzzled because it looks as if your "HITPAGE" is always going to be "HitLogger" and is therefore redundant (unless you have multiple hit logger procedures).
So I guess the real valuable part is the "RequestReferrer" which is always the page which calls the hitlogger.
I had a play and ending up putting the logging code into my "PageHeaderTag".
So, any pages which use the common header will automatically log their information. This saved me from having to insert the code into my pages.
Thanks again for sharing. i'd been meaning to add some logging for a long time.
25
Web Server - Ask For Help / Re: track incoming IP address
« on: July 30, 2008, 04:35:18 PM »
Can you elaborate on how you do the inline page call.
i.e. when/where do you call your hitlogger() procedure?
Thanks
i.e. when/where do you call your hitlogger() procedure?
Thanks
26
Web Server - Ask For Help / Re: <div>s and Source Procedures
« on: June 30, 2008, 02:06:28 PM »
i'm not sure if I understand you, but ...
I sometimes generate a simple table <table> ... </table> in an html string.
And I have this string a display field on my netWebForm.
Then if any of the fields change on the form, then under the Client properties for the field which changed, then set it to refresh my "htmlstring'.
This works for me to dynamically generate a table, and have it updates when the client changes fields on the form.
You may get some ideas by looking at the capesoft calculator example app.
The html string is refreshed everytime the user pushes a button. It's not a table in this case, but it could be.
I sometimes generate a simple table <table> ... </table> in an html string.
And I have this string a display field on my netWebForm.
Then if any of the fields change on the form, then under the Client properties for the field which changed, then set it to refresh my "htmlstring'.
This works for me to dynamically generate a table, and have it updates when the client changes fields on the form.
You may get some ideas by looking at the capesoft calculator example app.
The html string is refreshed everytime the user pushes a button. It's not a table in this case, but it could be.
27
Web Server - Ask For Help / Re: Firefox 3 supported?
« on: June 22, 2008, 12:47:02 PM »
Thanks Bruce. That works great.
It took me a long time to test, as for some reason I can no longer run my test app locally.
It's an HTTPS web app, and the live version (on our hosted server) as a valid certificate.
I just use the same certificate locally on my vista laptop and ignore the certificate error. But ... suddenly it now says "localhost:881 uses an invalid security certificate. ..." and doesn't give me any options to continue.
But the same program and certificate works fine on my xp desktop machine.
Odd..
But thanks for fixing FF3. Much appreciated!!!!!
Alan
It took me a long time to test, as for some reason I can no longer run my test app locally.
It's an HTTPS web app, and the live version (on our hosted server) as a valid certificate.
I just use the same certificate locally on my vista laptop and ignore the certificate error. But ... suddenly it now says "localhost:881 uses an invalid security certificate. ..." and doesn't give me any options to continue.
But the same program and certificate works fine on my xp desktop machine.
Odd..
But thanks for fixing FF3. Much appreciated!!!!!
Alan
28
Web Server - Ask For Help / Re: Remember TAB after SAVE record?
« on: June 20, 2008, 06:04:54 PM »
yes. I also posted an example app under another message (browse not retaining row on 2nd page).
http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=423.0
http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=423.0
29
Web Server - Ask For Help / Firefox 3 supported?
« on: June 19, 2008, 06:34:41 PM »
It seems as if all the AJAX functionality (e.g. column sorting, next/previous on browse) does not work in FF3.
If I use IE7, then it all works, but if I switch to FF3 it all stops working.
The odd thing is I've been using FireFox3 for 2-3 weeks (Release Candidate 1) and sometimes it has worked - but other times it doesn't work.
I get the same behaviour on 2 different computers (WinXp and Vista). I've checked "Tools | Options | Content" and I have both "Enable Java" and "Enable JavaScript" turned on.
I also get the same behaviour in the "web31 - Accounting" example app, as well as in my application.
Is anyone else having problems with FF3?
If I use IE7, then it all works, but if I switch to FF3 it all stops working.
The odd thing is I've been using FireFox3 for 2-3 weeks (Release Candidate 1) and sometimes it has worked - but other times it doesn't work.
I get the same behaviour on 2 different computers (WinXp and Vista). I've checked "Tools | Options | Content" and I have both "Enable Java" and "Enable JavaScript" turned on.
I also get the same behaviour in the "web31 - Accounting" example app, as well as in my application.
Is anyone else having problems with FF3?
30
Web Server - Ask For Help / Re: Retain row after changing record?
« on: June 19, 2008, 05:07:07 PM »
I''ve created a sample application to demonstrate the problem.
It uses the sql 2005 sample database AdventureWorks.
This can be downloaded form http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
This can be used to show two different problems:
1. Run, and choose "Product", then press "next" to go to 2nd page. Edit a record, and then press SAVE. Note that the browse is reset to the 1st item and does not remember the row.
2. Choose "Setup | Form - Tabs", change to the 2nd tab "SubCategory". Now Edit a record and press SAVE. Note that the page is reloaded and switches to the 1st tab.
"AdventureWorks.zip"
[attachment deleted by admin]
It uses the sql 2005 sample database AdventureWorks.
This can be downloaded form http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
This can be used to show two different problems:
1. Run, and choose "Product", then press "next" to go to 2nd page. Edit a record, and then press SAVE. Note that the browse is reset to the 1st item and does not remember the row.
2. Choose "Setup | Form - Tabs", change to the 2nd tab "SubCategory". Now Edit a record and press SAVE. Note that the page is reloaded and switches to the 1st tab.
"AdventureWorks.zip"
[attachment deleted by admin]