• 0

Command And Parameter [Visual Web Developer 2005]


Question

Hey People, Long time since ive posted in here. I have a little problem. For those of you who are familiar with the Microsoft Visual Web Developer tool I have a question to ask. For those who aren?t familiar with the tool I really suggest you take a look at it. Just a quick Google search away. It?s a free download from Microsoft and really handy for rapid development of webpage?s etc. Anyway as for my problem, here goes.

On my page I have several text boxes and I want to insert them into an SQL backend table (On the click of a button, But that work:pok :p ). I?m just taking a guess here and trying to use the feature as shown below. How do I use it because I?ve done all the obvious things but when it inserts the values into the table it just inserts the name of the parameter instead of the value from the textbox, if that makes sense? So if I had a parameter called "Description" that was linked to "TxtDescription" It would insert the value "Description" Into every record in the SQL table rather than the value in the text box. Can anyone shed any light please! Any help would be greatly appreciated.

1 answer to this question

Recommended Posts

  • 0

Are you trying to insert or update? Insert should just insert a new row with your value. Update is going to update every row, unless you differentiate in your where clause.

I have a stored proc that takes all those params. If the productId is null or 0, it performs an insert, otherwise, it takes that productId and applies an update where the row has an equivalent productId.

Edited by weenur
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • -- "So, how could the Trump team make such a mistake on something so politically important to them?" Because the Trump team didn't care enough about editing the embedded map on the website just like they didn't care enough about actually building a phone. They're just slapping Trump's name on some pre-built Chinese OEM Android phone and selling it to MAGA rubes. 🤣
    • Here in the UK we used to have a mobile network that would've been perfect for Trump. It was called ... Orange!
    • Trump's team takes down Trump Mobile coverage map that includes "Gulf of Mexico" by David Uzondu Image via Depositphotos.com When Donald Trump returned to office in January this year, one of the first things he did was sign an executive order to officially rename the Gulf of Mexico to the "Gulf of America". It was a signature move, but it seems his own team might have forgotten about it. The rollout for the new Trump Mobile service, a venture headed by his sons, is already facing issues with its pre-orders, and now has a whole new self-inflicted problem to deal with. A post from Travis Akers (@travisakers) has shown that the Trump Mobile official coverage map, intended to show potential customers their signal strength, prominently featured the name "Gulf of Mexico." It appears shortly after Akers's post went live, the Trump team took down the page, so if you visit trumpmobile.com/coverage, you would get a 404 error. Anyways, here's a screen recording of what the page looked like before the take down (double click to enlarge): So, how could the Trump team make such a mistake on something so politically important to them? From the recording, it looks like the coverage map is powered by Mapbox, a popular location platform for developers. Mapbox, by default, still uses "Gulf of Mexico" because its core map data is built on global sources like OpenStreetMap, which have not adopted the unilateral name change. Even though the official name is different in the US, these global datasets stick to the international consensus. Other tech companies, like Google, address this by changing their maps to display "Gulf of America" only for users in the US, a decision that annoyed the president of Mexico. The funny thing is, fixing this would have been pretty simple. Mapbox is quite flexible, and you can edit "natural features", including bodies of water. Here's how we did it (click to enlarge): The Trump Mobile coverage map has been offline for over five hours, as the Trump team presumably works to fix the issue and bring the page back online.
    • Maybe stop using that ###### once and for all? One can live withouth it. Anything META is cancer.
    • This also highlights the dangers of giving corporations unencrypted access to your documents / photos. It would appear this persons data has likely been scanned by Ai, which found something it didn't like, locking access to the account.
  • Recent Achievements

    • Week One Done
      rozermack875 earned a badge
      Week One Done
    • Week One Done
      oneworldtechnologies earned a badge
      Week One Done
    • Veteran
      matthiew went up a rank
      Veteran
    • Enthusiast
      Motoman26 went up a rank
      Enthusiast
    • Mentor
      M. Murcek went up a rank
      Mentor
  • Popular Contributors

    1. 1
      +primortal
      684
    2. 2
      ATLien_0
      266
    3. 3
      Michael Scrip
      194
    4. 4
      +FloatingFatMan
      177
    5. 5
      Steven P.
      140
  • Tell a friend

    Love Neowin? Tell a friend!