Andrew Asher
|
| Posted: 09/01/2002, 5:50 PM |
|
When I add another field in a grid from a joined table every field to the
right of that field disappears - remove the join in the Data Source and they
come back (minus of course the data from the previously joined table).
It was all working fine untill I changed the security settings - not related
but it seems that any other work on the page upsets the "join" in the data
source.
Now I cant get it to work for love or money - please dont say I have to
rebuild the entire page again (20th time now )
Any one have any ideas??
Thanks Andrew
|
|
|
 |
RonB
|
| Posted: 09/02/2002, 12:40 AM |
|
Did you try to define the join is it a left join or some other form. This
could just be a case of fine tuning the sql. Click with your mouse on the
connection from main table field and the joined table field. You will get a
menu allowing you to set the type of join.
RonB
"Andrew Asher" <andrew.asher@clear.net.nz> schreef in bericht
news:akucjt$ajo$1@news.codecharge.com...
> When I add another field in a grid from a joined table every field to the
> right of that field disappears - remove the join in the Data Source and
they
> come back (minus of course the data from the previously joined table).
>
> It was all working fine untill I changed the security settings - not
related
> but it seems that any other work on the page upsets the "join" in the data
> source.
>
> Now I cant get it to work for love or money - please dont say I have to
> rebuild the entire page again (20th time now )
> Any one have any ideas??
> Thanks Andrew
>
>
|
|
|
|
Andrew Asher
|
| Posted: 09/02/2002, 7:27 PM |
|
Yea I thought this was the issues as well. I fought with it for hours
trying this as well and finally gave up and just arranged the grid in a way
that it wanted to be in. Sigh!
Odly enough if you leave the origional reference field somewhere on the grid
the problem doesnt occur
"RonB" <r.borkent@123chello.456nl> wrote in message
news:akv4ma$k7f$1@news.codecharge.com...
> Did you try to define the join is it a left join or some other form. This
> could just be a case of fine tuning the sql. Click with your mouse on the
> connection from main table field and the joined table field. You will get
a
> menu allowing you to set the type of join.
>
> RonB
> "Andrew Asher" <andrew.asher@clear.net.nz> schreef in bericht
>news:akucjt$ajo$1@news.codecharge.com...
> > When I add another field in a grid from a joined table every field to
the
> > right of that field disappears - remove the join in the Data Source and
> they
> > come back (minus of course the data from the previously joined table).
> >
> > It was all working fine untill I changed the security settings - not
> related
> > but it seems that any other work on the page upsets the "join" in the
data
> > source.
> >
> > Now I cant get it to work for love or money - please dont say I have to
> > rebuild the entire page again (20th time now )
> > Any one have any ideas??
> > Thanks Andrew
> >
> >
>
>
|
|
|
|
DonB
|
| Posted: 09/02/2002, 7:35 PM |
|
I don't have a solution, but did run into what seems like this issue. I
changed the underlying view driving my grid and some fields just refused to
work right. I rebuilt my page from scratch, since that was virtually
painless, and fixed it (well, at least it made the problem go away ). I
think there is a mismatch in the CCP file vs what is in Common.Asp. I've
bravely deleted entire sections of the CCP with notepad, where certain
fields are described, and "fixed" difficulties with textboxes that would not
display data (even though they'd "save" to the database).
I edited a page with FrontPage and really screwed it up, even though I could
not see anything that looked wrong. All this makes me think there is
something out of place (located at the wrong offset in a collection or
array). I have definitely seen this in a one UPDATE method involving a memo
field - for some reason the code insisted the memo was parameter(1), when it
really was parameter(7). Again, rebuilding the page was quite easy and
resolved the problem for me - much faster than trying to find the root
cause.
don
"Andrew Asher" <andrew.asher@clear.net.nz> wrote in message
news:al16lv$cf9$1@news.codecharge.com...
> Yea I thought this was the issues as well. I fought with it for hours
> trying this as well and finally gave up and just arranged the grid in a
way
> that it wanted to be in. Sigh!
>
> Odly enough if you leave the origional reference field somewhere on the
grid
> the problem doesnt occur
>
>
> "RonB" <r.borkent@123chello.456nl> wrote in message
>news:akv4ma$k7f$1@news.codecharge.com...
> > Did you try to define the join is it a left join or some other form.
This
> > could just be a case of fine tuning the sql. Click with your mouse on
the
> > connection from main table field and the joined table field. You will
get
> a
> > menu allowing you to set the type of join.
> >
> > RonB
> > "Andrew Asher" <andrew.asher@clear.net.nz> schreef in bericht
> >news:akucjt$ajo$1@news.codecharge.com...
> > > When I add another field in a grid from a joined table every field to
> the
> > > right of that field disappears - remove the join in the Data Source
and
> > they
> > > come back (minus of course the data from the previously joined table).
> > >
> > > It was all working fine untill I changed the security settings - not
> > related
> > > but it seems that any other work on the page upsets the "join" in the
> data
> > > source.
> > >
> > > Now I cant get it to work for love or money - please dont say I have
to
> > > rebuild the entire page again (20th time now )
> > > Any one have any ideas??
> > > Thanks Andrew
> > >
> > >
> >
> >
>
>
|
|
|
|
RonB
|
| Posted: 09/03/2002, 12:24 AM |
|
Hi Don,
I've had this problem and it was solved when I removed all files from the
server and regenerated the thing entirely. Removing the backup html
files(the ones with ~ in it) in the project directory under codecharge
studio also helps. It looks to me that it sometimes uses an earlier version
of an html page. The php page is sending all kinds of stuff to the template
but if there isn't anything on the template to proces this information well
it just wouldn't work now would it 
So I now make it a habbit of removing(cleaning up so to speak) my project
files that are no longer valid and removing serverside any of the old files
and regenerate my project. The plus of this is that I now have a very tidy
directory on my server, containing only valid files and no old stuff that
isn't used anymore. I'm sure my co workers will appreciate this
RonB
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> schreef in bericht
news:al1760$dbk$1@news.codecharge.com...
> I don't have a solution, but did run into what seems like this issue. I
> changed the underlying view driving my grid and some fields just refused
to
> work right. I rebuilt my page from scratch, since that was virtually
> painless, and fixed it (well, at least it made the problem go away ). I
> think there is a mismatch in the CCP file vs what is in Common.Asp. I've
> bravely deleted entire sections of the CCP with notepad, where certain
> fields are described, and "fixed" difficulties with textboxes that would
not
> display data (even though they'd "save" to the database).
>
> I edited a page with FrontPage and really screwed it up, even though I
could
> not see anything that looked wrong. All this makes me think there is
> something out of place (located at the wrong offset in a collection or
> array). I have definitely seen this in a one UPDATE method involving a
memo
> field - for some reason the code insisted the memo was parameter(1), when
it
> really was parameter(7). Again, rebuilding the page was quite easy and
> resolved the problem for me - much faster than trying to find the root
> cause.
>
>
> don
>
>
> "Andrew Asher" <andrew.asher@clear.net.nz> wrote in message
>news:al16lv$cf9$1@news.codecharge.com...
> > Yea I thought this was the issues as well. I fought with it for hours
> > trying this as well and finally gave up and just arranged the grid in a
> way
> > that it wanted to be in. Sigh!
> >
> > Odly enough if you leave the origional reference field somewhere on the
> grid
> > the problem doesnt occur
> >
> >
> > "RonB" <r.borkent@123chello.456nl> wrote in message
> >news:akv4ma$k7f$1@news.codecharge.com...
> > > Did you try to define the join is it a left join or some other form.
> This
> > > could just be a case of fine tuning the sql. Click with your mouse on
> the
> > > connection from main table field and the joined table field. You will
> get
> > a
> > > menu allowing you to set the type of join.
> > >
> > > RonB
> > > "Andrew Asher" <andrew.asher@clear.net.nz> schreef in bericht
> > >news:akucjt$ajo$1@news.codecharge.com...
> > > > When I add another field in a grid from a joined table every field
to
> > the
> > > > right of that field disappears - remove the join in the Data Source
> and
> > > they
> > > > come back (minus of course the data from the previously joined
table).
> > > >
> > > > It was all working fine untill I changed the security settings - not
> > > related
> > > > but it seems that any other work on the page upsets the "join" in
the
> > data
> > > > source.
> > > >
> > > > Now I cant get it to work for love or money - please dont say I have
> to
> > > > rebuild the entire page again (20th time now )
> > > > Any one have any ideas??
> > > > Thanks Andrew
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Andrew Asher
|
| Posted: 09/03/2002, 3:10 AM |
|
Hmmmmm its funny you mention the memo field cos I did suspect this was the
problem field. By moving the "other" fields around the memo field it would
work or not. Likewise I suspect it was an old file or template type file
lurking about. Even with a "fresh" page I can duplicate it - like 2 or 3
tables then start moving the columns left and see what happens. A mismatch
of some sorts? Mismatch between CCS and SQL - Im lost.
Im happy enough with the result Ive now got so I will leave good enough well
alone.
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:al1760$dbk$1@news.codecharge.com...
> I don't have a solution, but did run into what seems like this issue. I
> changed the underlying view driving my grid and some fields just refused
to
> work right. I rebuilt my page from scratch, since that was virtually
> painless, and fixed it (well, at least it made the problem go away ). I
> think there is a mismatch in the CCP file vs what is in Common.Asp. I've
> bravely deleted entire sections of the CCP with notepad, where certain
> fields are described, and "fixed" difficulties with textboxes that would
not
> display data (even though they'd "save" to the database).
>
> I edited a page with FrontPage and really screwed it up, even though I
could
> not see anything that looked wrong. All this makes me think there is
> something out of place (located at the wrong offset in a collection or
> array). I have definitely seen this in a one UPDATE method involving a
memo
> field - for some reason the code insisted the memo was parameter(1), when
it
> really was parameter(7). Again, rebuilding the page was quite easy and
> resolved the problem for me - much faster than trying to find the root
> cause.
>
>
> don
>
>
> "Andrew Asher" <andrew.asher@clear.net.nz> wrote in message
>news:al16lv$cf9$1@news.codecharge.com...
> > Yea I thought this was the issues as well. I fought with it for hours
> > trying this as well and finally gave up and just arranged the grid in a
> way
> > that it wanted to be in. Sigh!
> >
> > Odly enough if you leave the origional reference field somewhere on the
> grid
> > the problem doesnt occur
> >
> >
> > "RonB" <r.borkent@123chello.456nl> wrote in message
> >news:akv4ma$k7f$1@news.codecharge.com...
> > > Did you try to define the join is it a left join or some other form.
> This
> > > could just be a case of fine tuning the sql. Click with your mouse on
> the
> > > connection from main table field and the joined table field. You will
> get
> > a
> > > menu allowing you to set the type of join.
> > >
> > > RonB
> > > "Andrew Asher" <andrew.asher@clear.net.nz> schreef in bericht
> > >news:akucjt$ajo$1@news.codecharge.com...
> > > > When I add another field in a grid from a joined table every field
to
> > the
> > > > right of that field disappears - remove the join in the Data Source
> and
> > > they
> > > > come back (minus of course the data from the previously joined
table).
> > > >
> > > > It was all working fine untill I changed the security settings - not
> > > related
> > > > but it seems that any other work on the page upsets the "join" in
the
> > data
> > > > source.
> > > >
> > > > Now I cant get it to work for love or money - please dont say I have
> to
> > > > rebuild the entire page again (20th time now )
> > > > Any one have any ideas??
> > > > Thanks Andrew
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
